Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Employee
Employee

Doesn't display total on window title?

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

Highlighted
Not applicable

Doesn't display total on window title?

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

Highlighted
Not applicable

Doesn't display total on window title?

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

Highlighted
Not applicable

Doesn't display total on window title?

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.

Highlighted
Not applicable

Re: Doesn't display total on window title?

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

Thanks,

Dinesh

Not applicable

Re: Doesn't display total on window title?

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

Highlighted
Not applicable

Re: Doesn't display total on window title?

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!

Highlighted
Not applicable

Re: Doesn't display total on window title?

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

Highlighted
Not applicable

Re: Doesn't display total on window title?

Thanks!

But how could i display expression total on window title?

Any insight would be much appriciate!

Regards,

Dinesh