Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
mp802377
Contributor

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

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?

top 10.PNG

Thank you,

Martha

6 Replies

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

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

mp802377
Contributor

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

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

May be this will address your confidentiality concerns

Preparing examples for Upload - Reduction and Data Scrambling

serj_shu
Valued Contributor

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

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.

mp802377
Contributor

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

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

mp802377
Contributor

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

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)

Community Browser