Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
thomas_2583
New Contributor II

Q1 Q2 Q3 Q4 Dates

Hi,

I have the following logic below to show 'Current Quarter'. 

I have 4 new Gauge's and need them to show as:

Quarter 1 - Current Year

Quarter 2 - Current Year

Quarter 3 - Current Year

Quarter 4 - Current Year

How would I tailor my logic below please to show the data values as above? 

Sum({$<[DATEIN.autoCalendar.InQTD]={1}, [DATEIN.autoCalendar.QuartersAgo]={0},
Named_seller = {'NT'},Type ={'New'},
[Country] = {'UK'}>} value)
+
Sum({$<[R.DATEIN.autoCalendar.InQTD]={1}, [R.DATEIN.autoCalendar.QuartersAgo]={0},
Named_seller = {'NT'},[R_Type] ={'New'},
[RCountry] = {'UK'}>} value_amount) 

Thanks

1 Reply
Partner
Partner

Re: Q1 Q2 Q3 Q4 Dates

Hi Thomas,

Best thing to do would be to get the Quarter field from the AutoCalendar and in your set expressions use, 'Q1', 'Q2' etc.. For each measure you use the different quarter.

Jordy

Climber

Work smarter, not harder