topic variable for quarter in set analysis in QlikView

variable for quarter in set analysis

lessassy — Sat, 16 Nov 2024 00:22:55 GMT

Hello everyone,

I have created a master calendar and i have a time dimenson called Quarter-Year which has value such as

'T1-2019', 'T2-2019' and so on....

The thing is i want to use a variable to compare let's say a value at T1-2020 to T1-2019.

Usually for year i use a variable so let's say vCurrentYear = max(year(DATE_Field)) and vPreviousYear = max(year(DATE_Field)-1)

I have a specific example which is :

if (Quarter-Year = 'Q1-2019',SUM({<CAT_CONTRAT = {'CDI'},[Quarter-Year] = {'Q1-2019'}>}ABS_DIR_JRS_OUV)/SUM({<CAT_CONTRAT = {'CDI'},[Quarter-Year] = {'Q1-2019'}>}NB_JRS_THEO_TRAVAIL),

if (Quarter-Year = 'Q1-2020,SUM({<CAT_CONTRAT = {'CDI'},[Quarter-Year] = {'Q1-2020'}>}ABS_DIR_JRS_OUV)/SUM({<CAT_CONTRAT = {'CDI'},[Quarter-Year] = {'Q1-2020'}>}NB_JRS_THEO_TRAVAIL),))

The result will be ok but i want to compare Quarter Year N to Quarter PreviousYear

DO you know how i could do that ?

Thank you a lot

In my master calendar the "quarter year" is this one: 'T' & ceil(Month(TempDate)/3)&'-'& Right(Year(TempDate),2) as QuarterYear,

Re: variable for quarter in set analysis

raji6763 — Mon, 06 Jul 2020 08:23:08 GMT

hi,

you may be try this

DATE= {">=$(=quarterstart(min(DATE),-4))<$(=quarterstart(min(DATE),-3))

https://community.qlik.com/t5/QlikView-Layout-Visualizations/How-compare-two-quarter-in-different-years/m-p/253983

regards,

raji

Re: variable for quarter in set analysis

lessassy — Tue, 07 Jul 2020 14:41:46 GMT

it worked thank you.

I tried also instead of

Quarter-Year = 'Q1-2019' i put Quarter-Year = 'Q1-'&'$(=vCurrentYear) or Previous Year and it work pretty well too.

Anyway thanks for the tips

Re: variable for quarter in set analysis

raji6763 — Wed, 08 Jul 2020 05:53:23 GMT

if you got solution.please close this thread.