topic Re: sales available for least year in QlikView

CAGR issue

gauthamchilled — Wed, 25 Nov 2020 16:16:04 GMT

I would like to show the sales for each country of their least year date. each country sales started in different different years. if i select 2015, i dont want to show zero but the sales available for least date or start date.

expected output

Australia 2013 32010

China 2014 70000

Newzealand 2012 2300

Taiwan 2012 310000

attached the file. can any one help?

Thanks

Gautham

Re: sales available for least year

Wed, 20 Jul 2016 02:44:07 GMT

choose Country as Dimension

Use expression:

firstsortedvalue({<Year=>}Sales,Year)

Re: sales available for least year

tamilarasu — Wed, 20 Jul 2016 02:45:43 GMT

Hi Gautham,

Have a look at the attachment.

Re: sales available for least year

gauthamchilled — Wed, 20 Jul 2016 03:06:14 GMT

Thanks tamil, i want to show max year sales in next column also. similar to min year sales. how can i do that?

Re: sales available for least year

gauthamchilled — Wed, 20 Jul 2016 03:08:56 GMT

actually i wanted to calculate CAGR..it works in text box on the line chart...but i wanted to show it in straight table with country as dimension it is not working

=pow(sum({$<Year={$(=max(Year))}>} sales)/sum({$<Year={$(=min(Year))}>}

sales),1/(max(Year)-min(Year)))-1

Re: sales available for least year

tamilarasu — Wed, 20 Jul 2016 03:14:44 GMT

Gautham,

You can add - sign before the sort-weight to get Max Period sales.

FirstSortedValue(Sales, -Period)

Re: CAGR issue

gauthamchilled — Wed, 20 Jul 2016 03:36:04 GMT

but i couldnt able to achieve using firstsortedvalue while calculating CAGR.

Re: CAGR issue

tamilarasu — Wed, 20 Jul 2016 03:37:02 GMT

Gautham,

I just want to cross verify the calculated values. Could you provide me your expected result / output for CAGR.

Re: CAGR issue

tamilarasu — Wed, 20 Jul 2016 03:52:09 GMT

Try this expression,

Pow((FirstSortedValue({1}Sales, -Period)/FirstSortedValue({1}Sales, Period)),1/(FirstSortedValue({1}Period, -Period)-FirstSortedValue({1}Period, Period)))-1

Re: CAGR issue

gauthamchilled — Wed, 20 Jul 2016 06:11:08 GMT

FirstSortedValue(Country,Period) as expression and country as dimension in straight table returns nothing...what could be the reason? any idea?

Re: CAGR issue

susovan — Wed, 20 Jul 2016 06:52:18 GMT

Hi Gautham,

Try this attachment,