topic Restricted dimension in QlikView

Restricted dimension

prrajendran — Sat, 16 Nov 2024 20:51:47 GMT

Hi Experts,

i have a straight table which has Reference number as dimension and two expressions.

my first expression brings the occurences of the reference number for the selected month

second expression brings the occurences of the reference number for the selected month and past 2 months from selection.

the expressions working fine.

but i want my dimension to be filtered only for the selected month.

i.e., 'RefA' reference number can be in multiple months

'RefB' in just the selected month.

then i want to display only 'RefB' in my dimension. how can i do this. please help

Re: Restricted dimension

Anil_Babu_Samineni — Thu, 16 May 2019 05:42:03 GMT

How is the measure looks like?

Re: Restricted dimension

prrajendran — Thu, 16 May 2019 08:26:04 GMT

Expression 1:
count(DISTINCT TOTAL<AcNo>{<full_date={">=$(=min(full_date))<=$(=max(full_date))"}>}ReferenceNo)
Expression 2:
count(DISTINCT TOTAL<AcNo>{<full_date={">=$(=addmonths(max(full_date),-3))<=$(=max(full_date))"},Month=>}ReferenceNo)