Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
swarup_malli
Specialist
Specialist

Make dims persist in a table (make them static )

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

6 Replies
sunny_talwar

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

swarup_malli
Specialist
Specialist
Author

Thank you for the response Sunny, Unfortunately can't  upload any attachment company policy

sunny_talwar

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

swarup_malli
Specialist
Specialist
Author

Thank you Sunny ,I found the solution.I had to make changes in the datamodel to get the desired results.My datamodel  had flaws

sunny_talwar

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

swarup_malli
Specialist
Specialist
Author

Will do