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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser2021
Contributor III
Contributor III

Qlik Sense SaaS Input variable in table

I have an input variable where a user can select a dimension from a drop down list to be displayed in a table.  Variable is   vCyclic1Value

The table then has a field defined as   ='$(vCyclic1Value)' and this works for all dimensions except for the calculated dimension.  For the calculated dimension (BalG)  it displays “BalG” in  each row of the table instead of the result of the calculated dimension.  If I add the calculated dimension "BalG" to the table as a column it displays the result of the calculated dimension correctly. 

  

My calculated dimension (BalG)

=class(    if([Balance]<$(VBalanceStart), $(VBalanceStart)-1 ,

             if([Balance] > $(VBalanceEnd), $(VBalanceEnd)+1 ,[Balance]))

      , $(VBalanceWidth), 'X', $(VBalanceStart)

      )

Labels (1)
0 Replies