@sandp707 I have not created anything in the Script. Everything was done in the front end only. Anyways I will take you through the steps, let me know if you can follow this. But this is going to be lengthy.
Step1: Below is the Script that was used:
NoConcatenate
Temp:
LOAD
Name,
Designation,
"Joining Month",
"Year",
CTC,
Gender,
Prefix,
Country
FROM [lib://Qlik Practice/Qlik Community Button.xlsx]
(ooxml, embedded labels, table is Sheet1);
NoConcatenate
ButtonObject:
Load * Inline [
ButtonName, Value
Yes, 1
No, 0
];
Exit Script;
Step2: I have created 8 chart(i.e. 8 straight tables) for 'YES' and 'NO' condition and added them to the master Items.
Step3: Then I made use of Container for Each of the above Condition,i.e. you need to create 4 Container containing 2 straight tables one is for YES and other is for NO.
Let me take a example of below condition to explain in detail:
chart 1: Show employee name
— If the filter XYZ is ‘YES’ then show the names of employees whose name length is more then 9 characters
— if the filter XYZ is ‘NO’ then show the names less than 9 characters
For Employees having more than 9 character, I created a straight table with 2 dimension.
a. Name : I used a calculated dimension like:if(Len(Name)>9,Name)
b. Length of the Name: I calculated Len(Name)
For Employees having less than 9 character, I created a straight table with 2 dimension.
a. Name : I used a calculated dimension like:if(Len(Name)<=9,Name)
b. Length of the Name: I calculated Len(Name)
Now add these 2 tables to master Item
Next Step is to create a Container object and add these 2 master items that you have created.
But the trick now for each master Item that you have added to the container, add the Show Condition Value=1 for YES and Value=0 for NO.
Step 4: Add the Filter Pane and Dimension for that is ButtonName.
Once this is successful please repeat for other 3 conditions.
