Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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