Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
swarup_malli
Valued Contributor

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

Tags (1)
6 Replies

Re: Make dims persist in a table (make them static )

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
Valued Contributor

Re: Make dims persist in a table (make them static )

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

Re: Make dims persist in a table (make them static )

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
Valued Contributor

Re: Make dims persist in a table (make them static )

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

Re: Make dims persist in a table (make them static )

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
Valued Contributor

Re: Make dims persist in a table (make them static )

Will do