Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Doesn't display total on window title?

Hello,

I have a straight table that count top 10 no. of viewings in expression (selected as expression total that shows value "21") as follow.

NameViewings

21
Alan 8
Garth Hill7
Ben Klein3
Ivan Totton2
jana hipkiss2
john edward2
John Morrison2
Kenneth Smith2
Martin  Phillips2
Michael  Burgess2

Now how can i display on the window title with total of viewings : 32 instead of 21?

Thanks!

11 Replies
kji
Employee
Employee

Maybe you should use "Sum of Rows"  instead of "Expression Total".

Not applicable
Author

Hello,

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)

Regards,

Amand

Not applicable
Author

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?

Thanks

Dinesh

Not applicable
Author

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.

Not applicable
Author

I have attached .qvw file. Hope you could help me.

Thanks,

Dinesh

Not applicable
Author

Dinesh,

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.

Regards,

Amand

Not applicable
Author

Thanks Amand,

This is really helpfull but i still want generate only top 10 for report which i am producing.

Any additional help would be appriciated!

Not applicable
Author

I think it's that you want .

Here, I modified the expression in order to display only the ten first values, and I changed the sort.

Regards,

Amand

Not applicable
Author

Thanks!

But how could i display expression total on window title?

Any insight would be much appriciate!

Regards,

Dinesh