Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
richard_chilvers
Valued Contributor

Implied Selections

I have a chart pivot table which uses a calculated dimension of product code and product description as:

'( ' & PROD_CODE & ' ) ' & PROD_DESC

eg. (1357) Jelly Babies

Users select a product to see the orders listed below it.

However, if they move to other tabs/charts the see details for all products because the PROD_CODE has not been explicitly selected.

Is there a way to implicitly select the PROD_CODE so they see what they expect to ? So if they select Jelly Babies in the pivot table, they only see that product on other tabs ?

1 Solution

Accepted Solutions

Re: Implied Selections

Hi Richard, it's possible to create that concatenation as a single field?, in script:

LOAD ...

     ( ' & PROD_CODE & ' ) ' & PROD_DESC as Product

....

Selections in Product will be unique per PROD_CODE and PROD_DESC

3 Replies

Re: Implied Selections

Hi Richard, it's possible to create that concatenation as a single field?, in script:

LOAD ...

     ( ' & PROD_CODE & ' ) ' & PROD_DESC as Product

....

Selections in Product will be unique per PROD_CODE and PROD_DESC

richard_chilvers
Valued Contributor

Re: Implied Selections

Yes - thanks for the hint.

MVP
MVP

Re: Implied Selections

Richard,

if you create a calculated dimension like above, and you select a dimension value in this chart, there should be automatically a selection in field PROD_DESC as well as in PROD_CODE.

What Ruben suggests should also work.

Or do the users select in a list box with field PROD_DESC? Then I don't understand why this selection does not limit the values of PROD_CODE as seen in the pivot chart also in other sheets.

What expressions do you use?

Could you upload a small sample that demonstrates that this is not working as expected?