Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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])