topic Re: Qlikview how to use alternate state in variable in QlikView

Qlikview how to use alternate state in variable

dwhanand — Tue, 09 May 2017 05:51:12 GMT

Hi all,

I have a dashboard with three sheets, the user asked selection of same dimension in one sheet should not affect other two sheets.

So i created three alternate state name from document properties and applied for each of the sheets.
Now i have a date range text box (action->select in field-> for a date dimension field) with logic as

= '>=$(=date($(vStartDateNxtAD))) <=$(=date($(vEndDateNxtAD)))' Note: i used two calendar objects and stored the value in variables

This logic worked before applying the alternate state. But after applying it stopped working i.e the charts and other associated object values in that particular sheet is not changing

The dashboard is in prod. Expecting a quikc answer.

Thanks in advance.

Re: Qlikview how to use alternate state in variable

ahaahaaha — Tue, 09 May 2017 06:04:23 GMT

Hi Anand,

Re: How can 'inherited' be used for an alternate state in a variable?

Regards,

Andrey

Re: Qlikview how to use alternate state in variable

dwhanand — Tue, 09 May 2017 07:09:12 GMT

Hi Andrey,

Thank you for your quick response. I tried using the variable as per the thread link

All the objects of my third dashboard sheet been changed to alternate state 'AccountDetail'

and changed the text box search logic as

= '>=$(=date($(vStartDateNxtAD('AccountDetail')))) <=$(=date($(vEndDateNxtAD('AccountDetail'))))'

Still the values are not getting changed for the date dimension (Action_due_date)

Re: Qlikview how to use alternate state in variable

dwhanand — Wed, 10 May 2017 04:51:05 GMT

Hi All,

Finally the search range worked. I didnt configure the alternate state for each of the text box action triggers. After setting the alternate state it worked.

Thank you..