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

Make dims persist in a table (make them static )

swarup_malli — Tue, 27 Sep 2016 16:58:38 GMT

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

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

sunny_talwar — Tue, 27 Sep 2016 17:02:52 GMT

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

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

swarup_malli — Tue, 27 Sep 2016 17:43:10 GMT

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

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

sunny_talwar — Tue, 27 Sep 2016 17:45:25 GMT

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

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

swarup_malli — Tue, 27 Sep 2016 18:58:49 GMT

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 )

sunny_talwar — Tue, 27 Sep 2016 19:00:10 GMT

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

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

swarup_malli — Tue, 27 Sep 2016 22:00:13 GMT

Will do