Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
cvasey76
New Contributor

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
Partner
Partner

Re: Counting Totals but disregarding specific Dimensions

add Month= in your set analysis

vishsaggi
Esteemed Contributor III

Re: Counting Totals but disregarding specific Dimensions

As Dilip suggested use your monthfield like below:

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