Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

nehapathak
New Contributor II

finding maximum or recent completed quarter

I have multiple values of quarters in filter pane- FY17 Q1 , FY17 Q2 , FY17 Q3, FY17 Q4 , FY18 Q1 , FY18 Q2

I want to create 2 measures to find out the count of employee id of  recent completed quarter i.e. FY18 Q2  in one measure

and count of employee id of  previous completed quarter i.e. FY18 Q1  in second measure

2 Replies
aronwilliamson
Contributor

Re: finding maximum or recent completed quarter

Could you provide us the app to work with or the table that you get the quarterly fields from

techvarun
Valued Contributor II

Re: finding maximum or recent completed quarter

A sample app would help here

Community Browser