Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Siggi_Swiss
Creator
Creator

Ad-hoc Table with Alternate States

I have issues to create a table in Qlik Sense with calculated conditions and Alternate States.

my steps:

  • went to master elements and created two date fields out of my Date field in the data modelSiggi_Swiss_0-1707228776064.png

     

  • i created a table with simple messures like sum(value) etc. and dimensions with a conditions like "=if(wildmatch(concat(GetFieldSelections(Dim),','),'*1*'),1,0)"
  • also i set a condition for the whole table 
  • Siggi_Swiss_2-1707228970740.png
  • now if i select a Dim the table show my measures and selected dimension - perfect
  • for comparison i duplicated the table
  • Now if i set the Alternate State, all conditions stop working!
  • Siggi_Swiss_3-1707229199086.pngSiggi_Swiss_4-1707229253707.png

     

    What can i do? Is this a Bug?

 

 

 

Labels (1)
12 Replies
Siggi_Swiss
Creator
Creator
Author

here you go, thx in advance

vinieme12
Champion III
Champion III

add calculation conditions to check for selections in both states

 

=if(GetSelectedCount(Dim)  or  GetSelectedCount(Dim,False(),'AlternateStateNAme') ,1,0)

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Siggi_Swiss
Creator
Creator
Author

thx for your reply. It doesn't work, also I don't want to select a Alternate State to show the table.

In my eyes its a bug in the Software. I'm on Version May 2023 Patch 3 btw.