Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Counting Totals but disregarding specific Dimensions

Hi

Can someone help me with the following:

I have this expression

COUNT(DISTINCT{<[Task AMS First creation Volume Flag]={1},[Gate DRD]={1}>}[AMS Document ID])

And the data is currently shown by month and Country Region

I want to show the data in another table by YTD, but i don't want the Month dimension to effect the YTD

Hope this makes sense.

Thanks in Advance

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

add Month= in your set analysis

vishsaggi
Champion III
Champion III

As Dilip suggested use your monthfield like below:

= COUNT(DISTINCT{<[Task AMS First creation Volume Flag]={1},[Gate DRD]={1}, MonthField=>}[AMS Document ID])