Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.