topic Re: Missing dimension values in QlikView

Missing dimension values

wale_martins — Sat, 16 Nov 2024 20:51:01 GMT

Hi there,

I’ve already created a calculated dimension to show months between a determined period and a expression to count visits in each month.

Calculated dimension:

=aggr(only({<MONTHYEAR={">=$(=monthstart(today(),-vRollingMonth))<=$(=monthend(today()))"}>}

MONTHYEAR),MONTHYEAR)

Expression

=count(dictinct VISIT_ID)

Both dimension and expression are working, but my problem is that the month is only shown when there's a VISIT_ID and I would like to show the months with no visits also. I've already unchecked "supress zero-values" but the problem continues.

Any help would be appreciated.

Wale

Re: Missing dimension values

sergio0592 — Sun, 19 May 2019 13:11:15 GMT

Hi,

Have you checked "Show all values" in the dimension tab?

Re: Missing dimension values

Anil_Babu_Samineni — Sun, 19 May 2019 15:03:16 GMT

Try this as filter and see what is the outcome?

=aggr(only({<MONTHYEAR={">=$(=monthstart(today(),-vRollingMonth))<=$(=monthend(today()))"}>}

MONTHYEAR),MONTHYEAR)

Re: Missing dimension values

wale_martins — Mon, 20 May 2019 13:14:43 GMT

Hi Sergio,

When you add a calculated dimensión, it's not possible to check "Show all values" option.

Re: Missing dimension values

wale_martins — Mon, 20 May 2019 13:45:17 GMT

Hi there,

I've finally solved my problem…

Dimension: I've avoided all the possible selections except the DATE one.

=aggr(only({<
COD_NAME=,NAME=,TYPE=,GROUP=,TAG=,
DATE={">=$(=monthstart(today(),-vRollingMonth))<=$(=monthend(today()))"}>}
MONTHYEAR),MONTHYEAR)

Expression 1: I've created an expression to count all visits between the selected period.

=Count({<
DATE={">=$(=monthstart(today(),-vRollingMonth))<=$(=monthend(today()))"}>}
DISTINCT ID_VISIT)

Expression 2: I've created an expression to count all the monthyear values between the selected period. (This expression Will be hidden)

=Count({1}DISTINCT MONTHYEAR)

RESULT:

If there's a better way to solve the problem, please let me know it.

Best Regards

Wale