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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
arezoo99
Contributor III
Contributor III

How can i refer to the calculated dimention in straight table

the script below works for dimensions but  does not work for calculated dimensions

How can i refer to the calculated dimention in the script below,,,

=if(Month(QVD_Fields)=GetFieldSelections(Month(QVD_Fields)),RGB (0,217,108),RGB(0, 164, 228))

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

If you look at the Current Selections, you'll see that a selection in this calculated dimension does nor produce selections in Month(QVD_FIelds), but rather the field "QVD_Fields".  So your background color expression should be something like:

=if(QVD_Fields=GetFieldSelections(QVD_Fields),RGB (0,217,108),RGB(0, 164, 228))


-Rob