topic Re: Set analysis and if inside value in QlikView

Set analysis and if inside value

Mon, 21 Mar 2016 08:23:54 GMT

Hi,

I have a little problem. I would like to have if-statement to decide my value within the set analysis.

Here is what I have tried:

varMaxDate is a variable, that holds the max date.

And I don't actually use YYYY or WW fields, I just needed to change them for security reasons.

=sum({<WW={'(if(isNull(GetFieldSelections(WW)),week(varMaxDate),WW))'}, YYYY={'(if(isNull(GetFieldSelections(YYYY)),year(varMaxDate),YYYY)'} >}#1)

Cheers,

Niko

Re: Set analysis and if inside value

sunny_talwar — Mon, 21 Mar 2016 09:49:09 GMT

Try this:

=Sum({<WW={'$(=If(IsNull(GetFieldSelections(WW)), Week(varMaxDate), WW))'}, YYYY={'$(=If(IsNull(GetFieldSelections(YYYY)), Year(varMaxDate), YYYY))'}>} #1)

Re: Set analysis and if inside value

Mon, 21 Mar 2016 10:21:34 GMT

Well that worked well, thank you!