topic Data Selection and Dimensions in QlikView

Data Selection and Dimensions

saifuddin — Sat, 16 Nov 2024 03:43:37 GMT

Hi All,

I need some advice with a problem I am trying to solve. My chart expression shows value only if the Dimension field in available on the sheet.

without dimension

Without Dimension week2 expression value in null.

with dimension

Expression:

=if(ValueList(CUM_WK2)=CUM_WK2 and CUM_WK2<>-1,

Count(DISTINCT (if(U18_DT>CUM_WK2, PEOPLE_ID))))

Appreciate your help.

Thanks

Saif

Re: Data Selection and Dimensions

asinha1991 — Mon, 29 Apr 2019 04:30:59 GMT

@saifuddin wrote:
Hi All,
I need some advice with a problem I am trying to solve. My chart expression shows value only if the Dimension field in available on the sheet.
without dimension
Without Dimension week2 expression value in null.

with dimension
Expression:

=if(ValueList(CUM_WK2)=CUM_WK2 and CUM_WK2<>-1,
Count(DISTINCT (if(U18_DT>CUM_WK2, PEOPLE_ID))))

Appreciate your help.

Thanks
Saif