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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
tinkerz1
Creator II
Creator II

Calculated dimension in an expression

I am trying to understand how a calculated dimension fits into an expression.

If I label the calculated dimension, why cant I use this in the set analysis part of the expression?

And what is the work around?

My calculated dimension

Label 'ABC Status'

=IF(len([Action])=1,IF(([Created Date]+[Days])>[Load Date],'On Track','Overdue'),'Placed')

My Set expression

=count(DISTINCT {$<[ABC Status]={'Overdue'}> + <[ABC]={'On Track'}>} [Action])

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Only fields can be used in set modifiers on the left side of the =. Expressions, expression labels and labels of calculated dimensions cannot be used.


talk is cheap, supply exceeds demand
MarcoWedel

As [ABC Status] = 'On Track' or [ABC Status] = 'Overdue'  should define the same set as Len(Action)=1 one solution might be:


=Count(DISTINCT {$<Action={"=Len(Action)=1"}>} Action)


QlikCommunity_Thread_171287_Pic1.JPG


hope this helps


regards


Marco