topic Re: "Show Others" and "Show Total" only in bars in QlikView

"Show Others" and "Show Total" only in bars

mp802377 — Wed, 14 Jun 2017 18:15:48 GMT

Hello,

I created a couple charts. Based off the slider the user would select 10 or 15 and it would chart the top 10 or top 15. They want another chart that just has the 'Show Others' and 'Show Total'. I had selected both on the 'Dimension Limits tab, but it is still charting the Top 10 (again based on the slider).

This is my first expression: sum({1<Week = {$(=Week(vLastWeek))} ,Year={$(varYear)}>}realdump+nodump)

And this is my line: sum(realdump+nodump)/Sum(Total realdump+nodump)

The first chart they love. The second (which is pretty much a copy of the first with the addition of Show Others' and 'Show Total'. But they only want to see the Show Others' and 'Show Total'. Is there a way to make that happen?

Thank you,

Martha

Re: "Show Others" and "Show Total" only in bars

sunny_talwar — Wed, 14 Jun 2017 18:21:24 GMT

Would you be able to share your app to see how the setup is?

Re: "Show Others" and "Show Total" only in bars

mp802377 — Wed, 14 Jun 2017 18:44:45 GMT

I cannot because it is confidential data.

realdump and nodump are both numbers. Like realdump might be 25 and nodump might be 100 for one ticket

The dimension is a concatenation of fields: = pgm & ' - ' & nbr & ' - ' & ticket

This is my first expression: sum({1<Week = {$(=Week(vLastWeek))} ,Year={$(varYear)}>}realdump+nodump)

And this is my line: sum(realdump+nodump)/Sum(Total realdump+nodump)

Re: "Show Others" and "Show Total" only in bars

sunny_talwar — Fri, 16 Jun 2017 00:37:30 GMT

May be this will address your confidentiality concerns

Preparing examples for Upload - Reduction and Data Scrambling

Re: "Show Others" and "Show Total" only in bars

Sergey_Shuklin — Fri, 16 Jun 2017 06:04:47 GMT

Hello, Martha!

Istead of usind dimension limits you can use a Rank() function to indicate a number of bars which user wants to see (using slider). It will reduce a headache with visual interpretation:

All values above rank()=slider_value is what user wants to see.

All values below rank()=slider_value is the analogue of "Others"

sum(total) is the Total bar.

Should work.

Re: "Show Others" and "Show Total" only in bars

mp802377 — Tue, 20 Jun 2017 17:27:30 GMT

I have this setup actually. The slider is setup and the vTop is in the Dimensions Limit tab.

I did find a work around for my problem

Thank you

Martha

Re: "Show Others" and "Show Total" only in bars

mp802377 — Thu, 29 Jun 2017 18:04:53 GMT

One thing I want to share if anyone else is having the problem is first I removed the dimensions (there should be nothing there) then I did below:

Top Selections: Sum(Aggr(If(Rank(Sum({$<Week = {$(=Week(vLastWeek))} ,Year={$(varYear)}>} my_calc)) <= vTop, Sum({$<Week = {$(=Week(vLastWeek))} ,Year={$(varYear)}>} my_calc), 0), type))

and my total (since I couldn't use the 'Dimension Limits'

Total: sum({$<Week = {$(=Week(vLastWeek))} ,Year={$(varYear)}>} my_calc)