topic Re: Last 2 Quarters data in QlikView

Last 2 Quarters data

simsondevadoss — Fri, 20 Nov 2020 18:02:30 GMT

Hi ,

I have a requirement in which I have to take bring data only for the current and last quarters . My quarters are like s1-2014, s2-2014,s3-2014 and s4-2014.

If my current quarter is s4-2014. I have to take only data for s4-2014 and s3-2014.

Thanks in advance.

Regards,

Simson

Re: Last 2 Quarters data

carvalguil — Fri, 03 Oct 2014 12:53:26 GMT

Something like this?

Re: Last 2 Quarters data

Fri, 03 Oct 2014 13:18:37 GMT

Hi Simson

you have 2 ways to do it.

Either when you load your script you set a flag (flag = 1) for current and previous quarters
and then you use it in your expression or calculated dimension

Either you use a conditrion straight in calculated dimension ((or may be in expression, i don't know your needs) based on specific variables like for example

if (yourQuaterFieldName = $(CurrentQuarter) or yourQuaterFieldName = $(PreviousQuarter), Expr)

you can use set analysis as well

best regards

Chris

Re: Last 2 Quarters data

simsondevadoss — Fri, 03 Oct 2014 14:44:22 GMT

Thanks for your reply.

I need to filter out in data model .

Regards,

Simson

Re: Last 2 Quarters data

giakoum — Fri, 03 Oct 2014 15:15:20 GMT

maybe the attached can help too :