topic Re: Set Analysis with if statement in QlikView

Set Analysis with if statement

Thu, 08 Oct 2015 15:27:36 GMT

How can I put this in a set analysis expression?

NextEventDate>(if(ASofDate>=vAsofDateFrom and ASofDate<vAsofDateTo , ASofDate))

TIA for the help.

Re: Set Analysis with if statement

sunny_talwar — Thu, 08 Oct 2015 15:31:38 GMT

May be something like this:

Only({<ASofDate = {"$(='>=' & $(vAsofDateFrom) & '<' & $(vAsofDateTo))"}>} ASofDate)

Assuming the above will only result in a single ASofDate

Re: Set Analysis with if statement

Thu, 08 Oct 2015 15:34:02 GMT

You mean...

Only({<NextEventDate= {"$(='>=' & $(vAsofDateFrom) & '<' & $(vAsofDateTo))"}>} ASofDate)

Thanks

Re: Set Analysis with if statement

sunny_talwar — Thu, 08 Oct 2015 15:36:23 GMT

Not sure what you are doing here -> NextEventDate>(if(ASofDate>=vAsofDateFrom and ASofDate<vAsofDateTo , ASofDate))

Are you checking if NextEventDate is greater than the right hand side of the expression?

Re: Set Analysis with if statement

Thu, 08 Oct 2015 15:37:14 GMT

Yes that is right.

Thanks

Re: Set Analysis with if statement

sunny_talwar — Thu, 08 Oct 2015 15:39:26 GMT

Would you be able to share few lines of sample data? It would be easier to understand your actual requirement looking at some data, rather than guessing what it might be

Re: Set Analysis with if statement

Thu, 08 Oct 2015 15:53:03 GMT

Thanks for your response. Unfortunately I can not share the data. But this is the expression I am trying in set analysis.

count(distinct (if([CMRNextDate]>AddYears(ASofDate,vFrequency) and [CMRDate]<=AddYears(ASofDate,vFrequency)

and [NextDate]>(if(ASofDate>=vAsofDateFrom and ASofDate<vAsofDateTo , ASofDate)) and EventDate<=(if(ASofDate>=vAsofDateFrom and ASofDate<vAsofDateTo , ASofDate)), CMR_FACT_KEY)))

Thanks for all the help.

Re: Set Analysis with if statement

sunny_talwar — Thu, 08 Oct 2015 16:26:38 GMT

Can you may be share some made up data which is similar to actual data. May be someone else can help you without the sample data, but for me, I would like to understand what you are trying to do and how it can be accomplished with set analysis.

Sorry for not being too helpful

Best,

Sunny