Discussion Board for collaboration on QlikView Scripting.
i'm a newcomer with qlikview and have my first problem. I try to load a file with many key figure columns. For example:
Now this is not very helpful when I want to report my count of members with age as dimension, because I don't have this dimension. How can I transform this model now to account model? For example:
Thank you very much!
thanks for your response. I've attached an excel-workbook with two sheets. The first sheet contains the data table and the second sheet shows the diagram.
Ok - I think I get it now!
You need to use the Crosstable() function. Look it up in the F1 help and the reference manual for the explanation but the load script should look something like this:
DROP TABLE Data_temp;
Try that - hope it helps.
look if the result is ok for u.
the script is simple:
LOAD * INLINE [
the dimension of 1st table is:
the dimension of 2nd table is:
if(aggr(only(age),name)>20 and aggr(only(age),name)<=40,'>=20 <=40','over'))
the expression is the same:
The problem with hardcoding the age ranges in your expressions is you have to update them all each time the data changes and introduces a new age. crosstable will always account for however many extra columns are added to the data source.
this is not true if u have a static range of age.
And the calculated dimension of the 1st table creates rows automatically.
I don't know if your solution works but it is so we have 3 possibility...
The QlikView Ways are infinite..