Solved: Re: Line Chart(trend analysis),Need to hide "other... - Qlik Community

Report Inappropriate Content · ‎2012-12-19

When I restrict the values to the top 6, im given a list of the top 5 customers and then the 6th is an accumulation of all the other customers.

So, for instance, if my sales figure was 100

Cust 1 - 10

Cust 2 - 5

Cust 3 - 3

Cust 4 - 2

Cust 5 - 4

Other - 76

I don’t want "others" while showing in the reports (it’s totally distorting the report) and while calculating trends I need those values?

I Have used set analysis in the dimension as aggr(if(rank(sum([Order Amount]))<=0,Customer),Customer)

Please help ASAP

Thanks

thomduvi83 · ‎2012-12-19

I would do that by reducing the Vendor in the expression in place of the dimension, using set analysis :

sum({<Vendor = {"=Rank(sum({$<Year={2010}>}Units))<=3"}>}Units)/

sum(Total <[Year]>[Units])

Look at this sample, % seems to stay the same

Regards,

Thomas

View solution in original post

Report Inappropriate Content · ‎2012-12-19

I believe what your problem is that you the show other option turned on.

Goto your charts Properties > Dimention Limits Tab > Uncheck Show Others

Anonymous · ‎2012-12-19

Check "Suppress when value is null" on the Dimensions tab.

Report Inappropriate Content · ‎2012-12-19

Hi Michael,

When i am suppressing the null values, we are losing some data. In expression i am using formula as below

=sum([Units])/

sum(Total <year>[Units])

As i am losing some information by suppressing it is showing wrong results...

As per my requirement i that data also but while showing i need to hide ..

Please Help

Anonymous · ‎2012-12-19

I'm not suggesting to suppress null values for expressions. I suggest to suppress null values for dimensions. Maybe you need to upload an example to clear my misunderstanding.

Regards,

Michael

Report Inappropriate Content · ‎2012-12-19

Hi Michael,

Please find the attached Qvw. I need to hide those others in line chart.

Thanks

Report Inappropriate Content · ‎2012-12-19

Hi rb,

After checking the dimension limits, uncheck the Others box in the dimensional limits,

Hope it helps

Regards,

ramesh

MayilVahanan · ‎2012-12-19

HI

PFA

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Anonymous · ‎2012-12-19

Yes, I understood it right first time.

Go to the chart properties, tab Dimensions. Select calculated dimension. After that, check the box "Suppress When Value Is Null". Click OK.

(See attached)

Regards,

Michael

Report Inappropriate Content · ‎2012-12-19

Hi Ramasamy,

Thanks for your reply,I dont wanna suppress the null values it changing the Actuall % values.

Please let me know is there is any other way to hide.

Thanks

Line Chart(trend analysis),Need to hide "others" while showing