topic Re: dynamically should be changed max year with quarter in QlikView

dynamically should be changed max year with quarter

Fri, 20 Nov 2020 18:02:30 GMT

Hi All,

In My Bar chart

My Dimension is

=Pick(Measure ,if(YEAR='$(=max({<NAME={A,B,C,D},QUARTER={'Q4'}>}YEAR))',

YEAR&'-'&QUARTER,

if(YEAR and QUARTER='$(=maxstring({<YEAR={$(=max(YEAR))}>}QUARTER))',YEAR))

,if(YEAR= '$(=max({<NAME={A,B,C,D}>}YEAR))'

and QUARTER='$(=maxstring({<YEAR={$(=max(YEAR))}>}QUARTER))', YEAR

))

Expressions are

=(Avg({<NAME={A},QUARTER={'Q4'}>}VALUE))

=(Avg({<NAME={B},QUARTER={'Q4'}>}VALUE))

=(Avg({<NAME={C},QUARTER={'Q4'}>}VALUE))

=(Avg({<NAME={D},QUARTER={'Q4'}>}VALUE))

Presently we are showing for the max year with quarter in the chart as dimension and we are restricting with quarter-Q4. But we have data for the latest year 2015 Q1,Q2 and we required to show fo only latest year as 2015 Q2 in the chart and previous years should be calculated only Q4 and shoudl be shown as 2012,2013,2014,2015-Q2.

The above process should be done dynamically.

Please help me on this jagan‌ MRKachhiaIMP‌

Re: dynamically should be changed max year with quarter

Kushal_Chawda — Mon, 28 Dec 2015 07:22:18 GMT

Would you be able to share the Sample?

For now try like below

Dimension:

YEAR

QUARTER

Expression

1) avg({<NAME={'A'},YEAR={"$(=max(YEAR))"}, QUARTER={"$(=maxstring({<YEAR={$(=max(YEAR))}>}QUARTER))"}>}Value)

2) avg({<NAME={'B'},YEAR={"$(=max(YEAR))"}, QUARTER={"$(=maxstring({<YEAR={$(=max(YEAR))}>}QUARTER))"}>}Value)

Re: dynamically should be changed max year with quarter

Mon, 28 Dec 2015 07:36:34 GMT

Hi Kush,

Many thanks for your reply.

But for the previous years 2014,2013 and soon i want to calculated only Quarter = Q4. For latest and max year i want to show which quarter is max. presently we have data for 2015 Q1 and Q2. now i want to show as 2015-Q2

Re: dynamically should be changed max year with quarter

Mon, 28 Dec 2015 09:25:38 GMT

Hi All

Please help me on this

Re: dynamically should be changed max year with quarter

Kushal_Chawda — Mon, 28 Dec 2015 10:15:36 GMT

when you will select the Year from list box it will automatically pick the latest quarter for that selected year

Re: dynamically should be changed max year with quarter

Tue, 29 Dec 2015 13:23:02 GMT

hi All,

here in bar chart dimension is calculated dimension - =if(YEAR=YEAR(Today()),YEAR&'-'&'QUARTER',if(DATE>='12/31/1916',YEAR))

My six expressions are =if(YEAR=YEAR(Today()),Avg({<NAME={'A'}>}VALUE),Avg({<NAME={'A'},QUARTER={'Q4'}>}VALUE)) and other expression are NAME= B,C,D,E

now i want to calculate latest QUARTER in the above epression.

Please let me know on this how to calculates latest quarter

Thanks

Avinash

Re: dynamically should be changed max year with quarter

Mon, 04 Jan 2016 12:35:47 GMT

hi All

please help me on this

Re: dynamically should be changed max year with quarter

koushik_btech20 — Mon, 04 Jan 2016 12:58:20 GMT

Hi Avinash,

You don't need to write or use calculated dimension, what you can want just wrote under set expression.

Just take YEAR as dimension and for max year and max quarter then expression will be like,

=Avg({<NAME={'A'},YEAR={'$(=MAX(YEAR))'},Quarter={'$(=Maxstring(Quarter))'}>}VALUE)

Re: dynamically should be changed max year with quarter

Mon, 04 Jan 2016 13:10:46 GMT

thank for your reply.

here i have data till 2015-Q2 only.

now my requirement in the x-axis year i want to display like this 2015-Q2,2014,2013,2012,2011 and soon

for 2014,2013,2012 and soon for these years the max quarter to be taken i.e Q4 valaves only should be taken for these years.

but for the 2015 year we have Q1 and Q2 so 2015-Q2 only shoul be display.

here we have two requirements

please let me know on this

Re: dynamically should be changed max year with quarter

koushik_btech20 — Mon, 04 Jan 2016 13:22:06 GMT

Hi Avinash,

So you need to show inside the dimension it will show, 2015-Q2,2014-Q4,2013-Q4,2012-Q4 and so .....

I thing you can do these things inside the script so it will be more easy for handling.

Regards,

Koushik

Re: dynamically should be changed max year with quarter

Mon, 04 Jan 2016 13:26:58 GMT

this requirement we have only this chart so i dont want to change anything in the datamodel level.

No it should show like this Only 2015-Q2,2014,2013,2012,2011,2010 in dimension

and from 2014 to 2010 for these years show be calaculate only Q4 quarter data

please suggest me

Re: dynamically should be changed max year with quarter

koushik_btech20 — Mon, 04 Jan 2016 13:32:04 GMT

Hi Avinash,

Not mentioning quarters for rest of the other years is ok. You can do these thing inside the script.

Thanks,

Koushik