How to write IF condition or Pick Match or any other way to write condition to get desired output in Qliksense Script Part
Hi Experts,
I have a like below and i want to get the out put also like below in Qlik Scripting part not in the frontend.
When i write the nested IF condition it is ready only Columns1 data(0,1) since the data is same in Column2 it is working like one to one relation and not passing to second condition.
Column1
Column2
Column3
Column4
Column5
1
0
1
0
1
0
1
0
1
0
0
1
1
0
1
0
1
1
0
0
0
1
0
1
0
1
0
0
1
0
1
0
1
1
1
1
0
0
0
0
1
0
1
1
0
1
0
1
1
1
1
1
0
0
0
Output:-
If(Column1=0 OR Column1=1,'Column1Data',
IF(Column2=0 OR Column2=1,'Column2Data',
IF(Column3=1 OR Column3=0,'Column3Data',
IF(Column4=0 OR Column4=1,'Column4Data',
IF(Column5=0 OR Column5=1,'Column5Data'))))) AS AllColumns_Data
in the front end filterpane should show the data in below format and when i select coulmn1Data from AllColumns_Data it should only "Column1" Data ,similarly when i select coulmn2Data from AllColumns_Data it should only "Column2" Data
I am getting Column1Data form Allcolumns_Data but i need only when I select Column1Data it should show only Column1Data(0,1), same way when i select Column2Data it should should show column2 data(0, 1).
Inside the all columns data is same but should behave like each condition data is seperate
