topic Re: If condition within Set analysis in QlikView

If condition within Set analysis

Wed, 29 Apr 2015 09:03:49 GMT

Hi,

we face the following problem:

Count({<closed_year={"$(=Date(Date#(Year(today()),'YYYY'),'YYYY'))"}>} DISTINCT ID) is working fine, but we need to add an if-statement within the set analysis.

If Month=January it should be (Date#(Year(today()),'YYYY')-1 ==> the year before; but how does the syntax work?

Thank you in advance!

Re: If condition within Set analysis

Wed, 29 Apr 2015 09:11:04 GMT

Hi Corinna,

I would recommend creating a variable which does the if statement and results in the correct end value. You can then use that variable in your set analysis

something like

create vDate variable

=If(Month(today())='Jan',Date#(Year(today()),'YYYY')-1, Date#(Year(today()),'YYYY'))

Count({<closed_year={"$(vDate"}>} DISTINCT ID)

just keeps your expression cleaner and means you can reuse the same variable for other expressions

Hope that helps

Joe

Re: If condition within Set analysis

Wed, 29 Apr 2015 09:12:05 GMT

Hi,

if(Month='January',Count({<closed_year={"$(=Date(Date#(Year(today()),'YYYY')-1,'YYYY'))"}>} DISTINCT ID),Count({<closed_year={"$(=Date(Date#(Year(today()),'YYYY'),'YYYY'))"}>} DISTINCT ID) )