topic Re: What Should be the expression in QlikView

What Should be the expression

kunkumnaveen — Mon, 08 Jul 2019 10:08:36 GMT

Hello All,

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

Data is in below format

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

olivetwist — Mon, 08 Jul 2019 13:02:07 GMT

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 — Mon, 08 Jul 2019 13:14:28 GMT

May be you can try something like this -

neelamsaroha157 — Mon, 08 Jul 2019 13:16:44 GMT

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

olivetwist — Mon, 08 Jul 2019 13:19:26 GMT

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