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: 
kunkumnaveen
Specialist
Specialist

What Should be the expression

Hello All,

In a three different text box i need to show  First, Second, Third max year and  Quarter

Data is in below format 

Capture.PNG

 

According to the above data F'19Q2, F'19Q1, F'18Q4 should be shown each value in each text box 

i tried multiple functions such as  Max, Firstsortedvalue etc but nothing is working 

Any suggestions Plz

Thanks

4 Replies
olivetwist
Creator
Creator

Try using the following:

=only(if(aggr(Rank(Sum(FYQU)),FYearQuarter)=1,FYearQuarter))

=only(if(aggr(Rank(Sum(FYQU)),FYearQuarter)=2,FYearQuarter))

=only(if(aggr(Rank(Sum(FYQU)),FYearQuarter)=3,FYearQuarter))

etc.

neelamsaroha157
Specialist II
Specialist II

May be you can try something like this - 

neelamsaroha157
Specialist II
Specialist II

You actually don't even need to create the date.  Check the updated one.

olivetwist
Creator
Creator

from what i can tell he is wanting to show "FYearQuater" in the text box, not "FYQU"