topic Re: Set Analysis and Alternate State in QlikView

Set Analysis and Alternate State

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the following expression which returns the results from the last 7 days from a date range selected by the user:

NUM(Sum({[DateCompare]<TestFlag={'Live'}, RefundOrSale={'Sale'},[Level 7]=$::[Level 7],[Level 2]-={'System/Refund','PAYG Pop card'},Date={">$(=Date(Max(Date)-7))<=$(=Max(Date))"}>} MonetaryValue),'£0,000')

This works great and other expressions without the " Date={">$(=Date(Max(Date)-7))<=$(=Max(Date))"} " means I can show total selection and last 7 days in the same report. Great.

Problem is my use of Alternate States. I have Date in a separate state called "DateCompare". The expression above ignores the Date selection in DateCompare and looks at the default state. I've tried replacing the $ with [DateCompare] but no luck.

Can anyone help with the expression so that the "last 7 dates" refers to the alternate state?

Thank you

Alex

Re: Set Analysis and Alternate State

sunny_talwar — Fri, 17 Jun 2016 12:09:03 GMT

May be try this:

Num(Sum({[DateCompare]<TestFlag={'Live'}, RefundOrSale={'Sale'},[Level 7]=$::[Level 7],[Level 2]-={'System/Refund','PAYG Pop card'},Date={">$(=Date(Max({DateCompare}Date)-7))<=$(=Max({DateCompare}Date))"}>} MonetaryValue),'£0,000')

Re: Set Analysis and Alternate State

swuehl — Fri, 17 Jun 2016 12:09:04 GMT

Try

NUM(Sum({[DateCompare]<TestFlag={'Live'}, RefundOrSale={'Sale'},[Level 7]=$::[Level 7],[Level 2]-={'System/Refund','PAYG Pop card'},Date={">$(=Date(Max({DateCompare} Date)-7))<=$(=Max({DateCompare}Date))"}>} MonetaryValue),'£0,000')

Re: Set Analysis and Alternate State

Fri, 17 Jun 2016 12:13:44 GMT

Thank you, works brilliantly.

Re: Set Analysis and Alternate State

Fri, 17 Jun 2016 12:13:55 GMT

Thank you, it works.