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

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

Wed, 19 Dec 2012 14:40:37 GMT

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

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

Wed, 19 Dec 2012 14:48:48 GMT

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

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

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

Anonymous — Wed, 19 Dec 2012 14:52:57 GMT

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

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

Wed, 19 Dec 2012 15:05:11 GMT

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

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

Anonymous — Wed, 19 Dec 2012 15:08:25 GMT

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

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

Wed, 19 Dec 2012 15:30:31 GMT

Hi Michael,

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

Thanks

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

Wed, 19 Dec 2012 15:32:40 GMT

Hi rb,

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

Hope it helps

Regards,

ramesh

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

MayilVahanan — Wed, 19 Dec 2012 15:33:51 GMT

PFA

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

Anonymous — Wed, 19 Dec 2012 15:35:14 GMT

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

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

Wed, 19 Dec 2012 15:42:45 GMT

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

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

Wed, 19 Dec 2012 15:46:42 GMT

Thanks Michael for your reply,When we suppress the null values it changing the Actuall % values.Which is not correct.Please let me know is there is any other way to hide those null values.

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

Anonymous — Wed, 19 Dec 2012 15:57:52 GMT

In this case, follow the suggestion with dimension limit - see attched:

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

thomduvi83 — Wed, 19 Dec 2012 16:11:21 GMT

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

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

Wed, 19 Dec 2012 16:28:43 GMT

Hi Michael,

Thanks
In dimensions I have used set analysis because I need to top 3 vendors of current year and need to create line chart for those vendors for the rest of the years. Excluding the other values need not suppress null values.Can we write any set analysis for this prob..

Really sorry for disturbing you..

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

Wed, 19 Dec 2012 16:41:05 GMT

Thank you very much Thomas

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

Anonymous — Wed, 19 Dec 2012 16:42:17 GMT

It's fine to keep the dimension calculated. I changed in for the simple reason, thought it's not necessary. That is, you can use both calculated dimension, use restriction on the "dimensions limit", not showing others.