Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
AndyC
Contributor II
Contributor II

How to spot an Alternate State has been chosen

Hi 

I'm using Alternate State in my QV document to compare two financial periods.

I have a table with a number of expression based columns and what I want to do is to hide the alternate state column if the user has not selected any of the alternate state options by using the conditional function on the Expression.

 

clipboard_image_0.png

 

Anyone got an idea how to do this? 

TIA

Andy

1 Solution

Accepted Solutions
rwunderlich

You can specify a statename in the GetSelectedCount() function like this:

=GetSelectedCount(Month, False(), 'mystate')

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

View solution in original post

3 Replies
Brett_Bleess
Employee
Employee

Just providing the Help for Alternate States, which may seem crazy, but there are some other features of Alternate States I am thinking you may be unaware that may provide a means to do what you wish here, in particular the StateName() function, thinking that may be what you need in your condition...

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Alternate%20States.htm

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
rwunderlich

You can specify a statename in the GetSelectedCount() function like this:

=GetSelectedCount(Month, False(), 'mystate')

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

AndyC
Contributor II
Contributor II
Author

That did the trick!

 

Thanks