Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
!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
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,
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.
Hello Jonathan Dienst,
Thanks for the explanation, appreciate it.
Thank you.