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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help in if condition

Hi Friends,

I have a table and the column name is customer_no and the set of values like (10,20,30,40,50,60,70, 80,90,100)

I would like to fetch a value on day basis

If Day(Today() =1 ,

If(WildMatch('10','20','30','40') , 'a1'

          If(WildMatch('50','60','70','80'), 'a2'

                    If(WildMatch('10','20','30','40','50','60','70','80','90','100'),  'a3' as GroupField;

the first and second part is working fine as I need to do work the third part, how do i do that

Please help me...

Regards

Chriss.

1 Reply
alexandros17
Partner - Champion III
Partner - Champion III

The field you need (GroupField) cannot contain at the same time value 'a1' and 'a3', to to this you have to add another field.