topic Re: Set Analysis - Expression in QlikView

Set Analysis - Expression

Mon, 15 Dec 2014 13:28:56 GMT

How can we write a set analysis in expression for displaying only those values of a field 'Field1' which are equal to 10?

Re: Set Analysis - Expression

rajeshvaswani77 — Mon, 15 Dec 2014 13:32:48 GMT

You will use Set Analysis where you need a aggregation. Not in this case. You can use a if condition here.

Thanks,

Rajesh Vaswani

Re: Set Analysis - Expression

anbu1984 — Mon, 15 Dec 2014 13:34:54 GMT

Sum({<Field1={10}>}Field2)

Re: Set Analysis - Expression

Mon, 15 Dec 2014 13:50:11 GMT

Please see the attached file. In the combo chart, I want that for the Year '2002', bar should not be displayed. Condition for the expression that I've written is: if(Year=2002,'0','1')

Please check what's wrong here.

Thanks!

Re: Set Analysis - Expression

anbu1984 — Mon, 15 Dec 2014 13:53:10 GMT

if(Year<>'2002',NumberOfParks)

if(Year<>'2002',NumberOfSchools)

Re: Set Analysis - Expression

rajeshvaswani77 — Mon, 15 Dec 2014 13:56:47 GMT

Hi Nishant,

Check attachment, have added the condition in the dimension. The else part i.e. 2002 will become null. Have suppressed nulls for dimension then.

thanks,

Rajesh Vaswani

Re: Set Analysis - Expression

Mon, 15 Dec 2014 14:14:46 GMT

Hi Anbu

Thanks for your reply. I made it using your approach. I made a slight change because for Year 2002, I just don't need bar. But line should always be displayed (even for Year 2002).

But I have a small doubt again. Please check the file attached. Instead of hard coding a value like in if(Year<>'2002',NumberOfParks), I would like to get '2002' from a field. This time the field can have more than 1 values. For example in the attached example, I have two values '2001' and '2002' in the Reference field. How to take these values into account?

Thanks!

Re: Set Analysis - Expression

Mon, 15 Dec 2014 14:18:21 GMT

Hi Rajesh

Thanks for your reply but I didn't want my dimension to disappear from display. That's whyI don't use condition in Dimension. However I have the problem of using filter value from another field. Please see the attached example. I have two values '2001' and '2002' in the Reference field. How to take these values into account for filtering bar in the combo chart?

Re: Set Analysis - Expression

anbu1984 — Mon, 15 Dec 2014 14:18:46 GMT

=if(Index(Concat(Reference,'|'),Year)=0 ,NumberOfSchools)

Re: Set Analysis - Expression

rajeshvaswani77 — Mon, 15 Dec 2014 14:27:04 GMT

Hi Nishant,

Anbu has given the correct answer.

thanks,

Rajesh Vaswani