Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sai_Mohan
Contributor III
Contributor III

How to give measure condition inside the existing dimension

Hi All,

Please help me with this.

I have if condition in my load editor. I need to include one more measure condition inside it.

If Condition - IF(MAX(TaskStatus)> 1 , MAX(TaskStatus),MIN(TaskStatus)) AS StatusID 

// Taskstatus is  a column with values (0 - open | 1 - complete | 2 - partial| 3 - done)

I need to include below measure, inside that if condition.

IF(TaskStatus = 1 AND CompletionDate <= (Duedate+7),  1,  0)  AS  t7.  /// Iam unable to use this TaskStatus column directly into that if condition, because of not having aggr function(Max,Min..) for this. Since the above if condtion has groupby clause.

 

Please help me with this. 

 

Thanks in advance!

Sai

Labels (2)
0 Replies