Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
dwhanand
Contributor II
Contributor II

Qlikview how to use alternate state in variable

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.

1 Solution

Accepted Solutions
dwhanand
Contributor II
Contributor II
Author

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..

View solution in original post

3 Replies
ahaahaaha
Master
Master

dwhanand
Contributor II
Contributor II
Author

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)

dwhanand
Contributor II
Contributor II
Author

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..

View solution in original post