Discussion Board for collaboration on QlikView Layout & Visualizations.
I am new to Qlikview and need some help.
I need to display frequencies and then for a frequency the percentages of a population that fall within a specific group.
The above total values are incorrect and should actually display:
For the frequencies in the table I have used the following expression:
But then to calculate a total I need to use count(distinct total <.......> if(StatusID=2,BenKey)) where in the <> I then quote the calculated expression aggr(count(DiseaseID), BenKey).
How would I quote then quote this expression, if I simply paste in into the count expression between the <> it doesn't work.
Please post some data. Without the file it is impossible to see what you should do, or understand your formulas.
For instance: What is BenKey? And why use Aggr()?
But to answer your last question: You cannot have an expression within the <...>. You need to have a field.