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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
vgadang1
Partner - Contributor III
Partner - Contributor III

Calculated dimension is not working

=if([Last Accessed Session] > 45, AppName, null()) This doesnt work as dimension but works as a measure, what am I doing wrong 

Here is the output, Test column is  expression =if([Last Accessed Session] > 45, AppName, null())  as master dimension, and Filtered apps column is same expression as master measure. Can someone help. 

vgadang1_0-1671577175091.png

 

3 Replies
mayuringale25
Partner - Creator
Partner - Creator

Hi @vgadang1 

Attaching a screenshot as the same is working on the side for both dimension and master dimension

Expression:IF([Last Accessed Session]>45,AppName,NULL())

mayuringale25_2-1671613920864.png

 

mayuringale25_1-1671613880690.png

 

 

Thanks and Regards
Mayur Ingale
vgadang1
Partner - Contributor III
Partner - Contributor III
Author

so my Last accessed session is a measure which calculates days since app was reloaded interval(today(2)-daystart(max(LogTimeStamp)),'d'). Is it possible that my calculated dimension is referring to the measure has to do with the problem. I am still struggling with this calcuated dimension. 

IS there an alternative solution to this? I just need to filter out the null rows from the table, is there a way to do that with a measure. 

Thanks,

Vidya

mayuringale25
Partner - Creator
Partner - Creator

Hi @vgadang1 

 

Can u share the the data along with qvf so I can check 

Thanks and Regards
Mayur Ingale