Discussion board where members can get started with Qlik Sense.
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
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' ,