Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
bhawana
New 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
Highlighted
Partner
Partner

Re: Multiple IF statement in sheet

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'
)))))