Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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