topic Re: Retaining Table structure same even on making selections. in QlikView

Retaining Table structure same even on making selections.

anshulsri — Wed, 25 Oct 2017 11:00:59 GMT

Hi All,

I have a project requirement like:

I have one straight table/Pivot table fully expanded and without any selection. When we do some selections the size of table gets reduced. But My requirement is, if we make some selections number of rows should not be affected i.e. the data relevant to selection should show the values and values of the dimensions values which are not related to selection should show 0.

If somebody has work around such requirement, please help me

Thanks a lot.

Re: Retaining Table structure same even on making selections.

MarcoWedel — Wed, 25 Oct 2017 19:52:52 GMT

please post a sample application

thanks

regards

Marco

Re: Retaining Table structure same even on making selections.

anshulsri — Fri, 27 Oct 2017 03:14:58 GMT

Hi Macro,

Apologies for late response.

I am trying to explain it through screenshots. I have attached the sample file too.

Re: Retaining Table structure same even on making selections.

shraddha_g — Fri, 27 Oct 2017 03:39:08 GMT

in your expression nullify selections.

For Ex. Sum({1}SalaryField)

Else Sum({<Location=,Office=>}SalaryField)

Use and Modify it according to your current expression

Re: Retaining Table structure same even on making selections.

anshulsri — Sat, 28 Oct 2017 14:37:22 GMT

Hi Sraddha,

Here we have to enable the selections and all the dimension values should come in the table and calculation should be changes according to the selection(if it comes in the selected filter category) or 0.

In your case there will be no impact of selections on expression value.