topic Re: yaer & quarter in QlikView

yaer & quarter

Anonymous — Tue, 20 Oct 2015 05:44:57 GMT

hi,

i load in script feild with "year & quarter".

i want in pivot when i chose 2014-q4 , to see detail from Previous quarters.

i use this - count({<year-q={"$(=Max(year-q)-1))"}>}tools)

thanks'

yarin.

ecolomer — Tue, 20 Oct 2015 05:51:10 GMT

And what is the question?

Can you explain more, please?

Tue, 20 Oct 2015 05:51:34 GMT

Hi Create Two Variables for Current Quarter and Last Quarter and use them in the Expression, if you can't do it please share some sample data.

Regards

John

avinashelite — Tue, 20 Oct 2015 05:53:54 GMT

try like this :

create a variable with this expression:

vCurrentQuarter

subfeild(getfieldselection(year-q),'-',1)&'-'&'q'&(Num(purgechar (subfeild(getfieldselection(year-q),'-',2),'q'))-1)

then

count({<year-q={"$(=vCurrentQuarter)"}>}tools)