Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'
)))))