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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
lucasx15
Contributor III
Contributor III

Only in Set Analysis

Hi, everyone!

 

I have this expression: 

 

(Only({<DT_CALENDAR_YEAR={2022}>} $(vQtdeExaDiarys))-Only({<DT_CALENDAR_YEAR={2020}>}$(vQtdeExaDiarys)))
/
Only({<DT_CALENDAR_YEAR={2020}>} $(vQtdeExaDiarys))

 

I have this expression: But my account is returning null value. Is the way to use a variable (vQtdeExaDiarys)  in Only correct?

 

Labels (1)
1 Reply
rubenmarin

Hi, hard to say without knowing what vQtdeExaDiarys stores, if it's a field name and that field has only one possible value it might work, in other case probably not.