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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Expression to Calculated dimension

Hi All,

I have below expression like :

count(Distinct {<SEVERITY_NAME={'A' }>}if(CREATE_DATE<DepDate and (isnull(CLOSE_DATE) or CLOSE_DATE>=DepDate),ID))
+
count(Distinct if(CREATE_DATE>DepDate,ID))

 

How can I write this as a calculated dimension ?   Need your help and support 

Thanks 

Labels (1)
3 Replies
smilingjohn
Specialist
Specialist
Author

Hi Expertise any help on my post ..

 

Thanks 

smilingjohn
Specialist
Specialist
Author

Hi All,

Is this not possible ?

smilingjohn
Specialist
Specialist
Author

I tried all that i can do but no luck ...

hoping for help from any expertise 

 

Thanks