Multiple IF statement in sheet

[bhawana]

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

[Stoyan_Terziev]

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