Syntax Error - Press Play on Tape -

31Oct/1214

QlikView LEF generator

Use the link below to generate a QlikView License Enabler File - LEF:
http://lef1.qliktech.com/manuallef

QV LEF generator

QlikView LEF generator

Filed under: QlikView 14 Comments
9Jul/121

QlikView concatenate multiple QVD files

MyTable:
LOAD * Inline [
DummyField
];

CONCATENATE LOAD * FROM QVDFileName*.qvd (qvd);

DROP FIELD DummyField FROM MyTable;

Filed under: QlikView 1 Comment
11Aug/1011

QlikView – Dynamic columns in chart straight table

I am a BI consultant currently working on the biggest QlikVIew partner deal of 2009.
One of my clients requested a table with non-static columns, ie. dynamic number of columns.

The below two solutions show a chart straight table with dynamic columns:

  1. This solution chooses fields from the system field $Field with a condition of what table the fields should be selected from
  2. This solution iterates through all fields in a table and creates a data island with the input table field names.

Both solutions have the same four expressions:

  1. Chart calculation condition and error message if condition not met
  2. Dimension expression
  3. Label expression
  4. Dimension show condition expression

Solution #1 is good because you don't get an extra data island and can use the tables you already have.

However, a disadvantage is that if you use the $Field field anywhere else, you will have selections you might don't want which will affect the chart expressions.

Solution #2 is good because it is separated from the data model itself.
It is also a cleaner and more secure solution. You can specify exactly which fields you want by modifying the load script and transforming it the standard way.

I hope you all find this useful.

Cheers!

OPEN SOURCE FOR THE WIN!

Download here: Dynamic_columns_in_chart_straight_table.zip