topic Re: Expression into dimension in QlikView

Expression into dimension

smilingjohn — Thu, 03 Mar 2022 09:31:03 GMT

Hi All,

I have below expression as :

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))

Now I need to write the same expression as a

Calculated Dimension .need help in getting this

Thanks in Advance

Re: Expression into dimension

smilingjohn — Thu, 03 Mar 2022 09:29:43 GMT

Hi Expertise

Any help on my post

Thanks

Re: Expression into dimension

smilingjohn — Thu, 03 Mar 2022 15:41:44 GMT

Hi All,

Is this not possible ? or no way to achieve the above expression as a calculated dimension ?

Re: Expression into dimension

Raja2022 — Thu, 03 Mar 2022 16:11:53 GMT

Give a try using Aggr() function and also look into this link and see if that helps:

https://community.qlik.com/t5/QlikView-App-Dev/Calculated-Expression-Use-as-a-Dimension/td-p/1547832

Re: Expression into dimension

smilingjohn — Fri, 04 Mar 2022 17:14:34 GMT

This did not help ...I am really stuck with this now