topic Re: Click on Pivot Table click on expression current selection show others field in QlikView

Click on Pivot Table click on expression current selection show others field

nicholas5141 — Wed, 25 Nov 2020 16:16:04 GMT

!Hi All,

When I click on pivot table expression it show other fields on current selections.

Is there anything I can do to fix it? As I want to make it consistent when user click on expression value current selections should show the selected value/field only.

Screenshot & Sample Apps Attached

Thanks you

Re: Click on Pivot Table click on expression current selection show others field

jonas_rezende — Tue, 24 May 2016 13:39:44 GMT

Hi, Nic Nic.

I think didn't understand your dubit. Anyway, I saw that the field name was wrong in the [TOTAL] expression, instead of Sum(Total). Fixed!

The simulation in the current selection of Dimension and Expression fields worked as selected.

What do you want to achieve with the result?

Re: Click on Pivot Table click on expression current selection show others field

Anil_Babu_Samineni — Tue, 24 May 2016 13:46:23 GMT

Me too,

I don't know why are you taking expression as Sum(Total) --> There is no Total Field ....

Please send me the required Exact O/P

Re: Click on Pivot Table click on expression current selection show others field

jonas_rezende — Tue, 24 May 2016 13:57:53 GMT

The table TMP contains two fields: Name and Total. In the upload filed by Nic Nic.

Re: Click on Pivot Table click on expression current selection show others field

nicholas5141 — Wed, 25 May 2016 06:59:06 GMT

Hi sorry qvw updated!

Re: Click on Pivot Table click on expression current selection show others field

nicholas5141 — Wed, 25 May 2016 11:18:00 GMT

Hi sorry qvw updated!

Re: Click on Pivot Table click on expression current selection show others field

nicholas5141 — Wed, 25 May 2016 11:18:11 GMT

Hi sorry qvw updated!

Re: Click on Pivot Table click on expression current selection show others field

jonas_rezende — Wed, 25 May 2016 12:46:59 GMT

Hi, Nic Nic.

The object current selections shows the value and name of the existing fields in the data model. An expression is an aggregate function, where the field is passed to a function. Ex.: Sum(), AVG(), and others. So when the selected object appears in the available dimensions in your chart, like:

Selection in dimension Customer, appears name and value Customer;
Selection in dimension Product, appers name and value Product;
Selection in expression, appears all the dimensions to the value chosen.

Hope this helps!

Re: Click on Pivot Table click on expression current selection show others field

nicholas5141 — Thu, 26 May 2016 00:43:01 GMT

Hi the problem i facing is point 3

3. Selection in expression, appears all the dimensions to the value chosen.

Is there any way to prevent it? or any setting that I can change? So when user click on expression current selection is show expression clicked value / expression only?

Thanks

Re: Click on Pivot Table click on expression current selection show others field

jonas_rezende — Thu, 26 May 2016 13:05:14 GMT

Hi, Nic Nic.

If there is any alternative, unfortunately, I don't know.

Regards,

Jonas Melo.

Re: Click on Pivot Table click on expression current selection show others field

PrashantSangle — Thu, 26 May 2016 13:12:52 GMT

Hi,

Current selection box only shows dimension value, It will never shows expression.

or we can say only field name and respected value which is available in table.

Regards,

Re: Click on Pivot Table click on expression current selection show others field

jonathandienst — Thu, 26 May 2016 13:19:28 GMT

An expression is not selectable. If you think about, what would you do with that selection as the expression only exists in the sheet object in which it is calculated. So the result of clicking the expression is to make a selection of all the dimensions in the sheet object that identify that line. This is how Qlikview works.

The same applied with a calculated dimension. "Selecting" a value has the effect of selecting the relevant underlying field values.

Re: Click on Pivot Table click on expression current selection show others field

nicholas5141 — Fri, 27 May 2016 00:43:01 GMT

Hello Jonathan Dienst,

Thanks for the explanation, appreciate it.

Thank you.