topic Re: Always one selected value in QlikView

Always one selected value

MindaugasBacius — Fri, 10 Aug 2018 10:23:22 GMT

Hello,

I do face some issue with option Always one selected value.

I have few sheets in an app. All the sheets have the same dimension called Date.

In one of the sheets I need to apply Always one selected value for Date dimension. Unfortunately, when I choose this option it applies to all the sheets.

What would be the workaround for this kind of problem?

Thank you in advance!

Re: Always one selected value

tresB — Fri, 10 Aug 2018 10:29:26 GMT

May be create an alternate state and assign it to the date field where specifically the 'Always One Selected Value' would be required. However, as an extra you have to include this date field (in alternate state) all the expression explicitly in that sheet.

Re: Always one selected value

niclaz79 — Fri, 10 Aug 2018 10:32:09 GMT

This one is a bit tricky, but I would create an island table with all the possible dates, column called DateSelection or similar.

DateSelectionTable:

LOAD distinct

Date as DateSelection

Resident ...;

Then I would use that dimension in the sheet you need to be always one selected as the date selection. In the expression than you can reference the selected date in the set-expression using Date = P(DateSelection). This way you are not interfering with the Date-dimension in any way outside that expression.