topic Re: answer in QlikView

answer

Fri, 15 Jun 2012 20:07:37 GMT

i have a group column type are like abc,cba,dac,Others.when i use it as dimension and take sum of sales

in bar chart i get sum of abc,cba,dac,Others , i dont want to show Others on chart .

is it possible? if yes then how?

Re: answer

Fri, 15 Jun 2012 20:13:37 GMT

Have a conditional Dimension if(dim='Others',Null(),dim) and make sure you select "Supress when value is Null" for the dimension.

Let me know if it works.

Regards

Priya

Re: answer

Fri, 15 Jun 2012 21:20:21 GMT

its not working

i m attaching qvw.

in grapth i dont want to show others.

Re: answer

Fri, 15 Jun 2012 21:44:38 GMT

Please see attached.

The chart on the right is duplicated, because I have my solution (applying a setAnalysis to exclude others...) and the answer suggested by Priya Kakarla.

Both give the same values.

Does this help you?

Re: answer

Fri, 15 Jun 2012 22:09:48 GMT

i am not able to open your qvw

but i have used above expression and its not working .

i m still getting others count on chart.

Re: answer

Fri, 15 Jun 2012 22:57:25 GMT

Do you have the personal edition?

Re: answer

erichshiino — Sat, 16 Jun 2012 03:11:32 GMT

Hi,

You can change your set analysis to exclude 'others' from your possible values in the dimension:

Sum({<[month]={$(vmonth)}, tg-={other}>}visit)

and

Sum({<[month]={$(cmonth)}, tg-={other}>}visit)

Hope it helps,

Erich

Re: answer

Sat, 16 Jun 2012 09:58:56 GMT

Enrichs solution is the one I also suggested.

In addition, the first suggestion (from priya) also works: the expression in your dimension then is

=if(tg='other',null(),tg)

Make sure that this calculated dimension is the only one and that that checkbox is activated (named "suppress when value is null").

I think the SetAnalysis is the better option.