Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi have a table object it has 1 dimension and 2 expressions.
My requirment is when a user makes a selection on a filter the columns in table should persist
Ex In the below ex ,by default the values are displayed as shown below
dim measure
1 Honda Civic $1000
Now when a user makes a selections in one of the filters ,and the value 1 Honda Civic may not not meet the selections criteria,so by default it disappeares ( that's how qlik is designed to behave),but I want the chart to overide that behavior,it should display NULL in the expression (see below)
dim measure
1 Honda Civic NULL
I don't want to use {1} in the set expression nor 'Dimension=' inside nor Total qualifier in the set expression,they don't give me the desired result
May be share a sample with the expected output based on your selection because just by looking at description isn't helping much
Best,
Sunny
Thank you for the response Sunny, Unfortunately can't upload any attachment company policy
Provide dummy data in Excel file or copy paste it directly here from the Excel file? And also what the result you expect to see
Thank you Sunny ,I found the solution.I had to make changes in the datamodel to get the desired results.My datamodel had flaws
Awesome, I am glad you were able to figure this one out. For future reference, please provide us with some kind of sample (whatever is possible) so that we can help you quickly.
QlikCommunity Tip: How to get answers to your post?
Best,
Sunny
Will do