Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rajeshqvd
Contributor II

Pivot table Expression cell is Selectable ?

HI,

 

I have requirement  need to select Pivot expression value and below table should get reflect pivot selections. Please suggest if any Extension available for this...?

Pivote Selectable.PNG Thanks,

Labels (2)
4 Replies
Partner
Partner

Re: Pivot table Expression cell is Selectable ?

Hi Rajesh,

You want the possibility to select the 425?

Jordy

Climber

Work smarter, not harder
rajeshqvd
Contributor II

Re: Pivot table Expression cell is Selectable ?

Hi Jordy,

Requirement is user should select Measure.

Thanks,
Highlighted
MVP
MVP

Re: Pivot table Expression cell is Selectable ?

Measures and calculated dimensions are not selectable. Selections are global to the entire app, but expression values and calculated dimension values exist only on the context of the pivot table. So selections can only be made against actual field values.

Even selecting a calculated dimension value selects the underlying field values.

You will need to look for an different way to resolve this issue.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Partner
Partner

Re: Pivot table Expression cell is Selectable ?

Hi Rajesh,

As @jontydkpi mentioned, what you want to accomplish is not possible. If you do want this possibility, you should create the value of 425 in your data model and get the value in a table as a dimension.

Jordy

Climber

Work smarter, not harder