Hello,
I have used filter panes in one of my sheet in qliksense. One of the filters is to select Gender. The filed name in my data source is Gender and it has rows for F (as female) and M( as male). Previously, I had this expression behind my filter
if(Gender='F','Female',if(Gender='M','Male')). it works fine.
Now user wants that every time they open the sheet it filters out the report automatically or by default to Male. and later, if they need then change and select the Female option in the filter.
I have set this variable in the main section in data load editor SET vDefaultFilter='Male', and modify the expression like this: if(Gender='F','Female','$(vDefaultFilter)')
the expression says ok but it does not filter data by default to Male. I still need to go and select Male option.
could someone help please?
Thank you!
