Hi,
I drill down the two dimension
1st is =If([E5-1]='Yes',Dual('Y',1),if([E5-1]='No',Dual('N',2)))
2nd is Office
The bar chart is there only one type of value in particular office hence its drill down in directly to the office
But , the user requirement is When we put a filter on office we get the Yes and No only.
If its possible in qliksense we can so Yes or No
Please help me out solve the problem
Thanks,
princy