Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a straight table that count top 10 no. of viewings in expression (selected as expression total that shows value "21") as follow.
Now how can i display on the window title with total of viewings : 32 instead of 21?
You can modify the behavior of your total column with test on the first row. Modify your expression like this :
if(rowno()=0, your_total_expression, your_top_10_expression)
Thanks for the response!
I have dirlled down top 10 rows by limiting Max number "10" on properties-->presentation-->Max number "10"
My expression is count(distinct id) and dimension is "name".
could you please help on expression with based on above?
If I understand your problem, I agree with the John's solution ie select "Sum of Rows" instead of "Expression Total".
If it doesn't work as you want, can you attach your qvw file please.
The rank() function let you do a ranking according to your expression. See the attached file.
I have modified the calculated dimension in order to add the ranking (I select the Top ten values), I have used the John's solution and I have added an expression so that you understand the ranking.
Because of the ex-aequo values, you have a top 12 rather than a top 10.