Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
prrajendran
Contributor III
Contributor III

Restricted dimension

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

Labels (1)
2 Replies
Anil_Babu_Samineni

How is the measure looks like?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
prrajendran
Contributor III
Contributor III
Author

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)