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
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
bhawana
Contributor II
Contributor II

Multiple IF statement in sheet

Hi All,

I have to create a filter as (reading_materia)l with four columns A, B, C and D and I have to do this only on sheet.

How can I do this ?

if(A = 0,'Book',
if(A= 1,'Pen' ,
if(B= 1,'Eraser' ,
if(C= 1,'cutter' ,
If(D =1,'pencil'
))))) as reading_material

Thanks In Advance

1 Reply
Stoyan_Terziev
Partner
Partner

Hey,

 

Cant you create this field in the backend?

Qlik Sense will show the formula instead of the value if you just put it in a filter pane.

 

Can you try to create a dimension master item to put in a filter pane using this formula:

Name this dimension reading_material

 

if(A = 0,'Book',
if(A= 1,'Pen' ,
if(B= 1,'Eraser' ,
if(C= 1,'cutter' ,
If(D =1,'pencil'
)))))