topic Re: Selecting Latest Quarter in QlikView

Selecting Latest Quarter

Anonymous — Mon, 01 Jul 2013 19:22:09 GMT

I need to create a line chart by selecting the latest year and quarter. PERIOD field has values like:

2013 1Q

2013 1H

2013 2Q

2013 FY

2012 4Q

2012 2H

...

I need to look for 2013 2Q for example.

Is there any finction that I could use or need to split it by Substring() ?

Nicole-Smith — Mon, 01 Jul 2013 19:37:47 GMT

=maxstring({<PERIOD = {'???? ?Q'}>}PERIOD)

Anonymous — Tue, 02 Jul 2013 15:44:04 GMT

This worked fine in a Text Object but can't seem to use it as a calculated Dimension in a Straight Chart.

Nicole-Smith — Tue, 02 Jul 2013 15:48:11 GMT

Make a variable (i.e. vMaxQuarter with the expression from above), then make your dimension on the chart:

=if(PERIOD = vMaxQuarter, PERIOD)