topic Re: Set analysis issue for quarter in QlikView

Set analysis issue for quarter

Thu, 06 Feb 2014 19:28:28 GMT

Hi,

i have req like to show sum(sales) of Q1 last month to Q4 in the previous year 2nd month.

regards

Mahesh Thalluri

Re: Set analysis issue for quarter

Thu, 06 Feb 2014 19:32:26 GMT

CAn you explain more details about your problem?

Re: Set analysis issue for quarter

Thu, 06 Feb 2014 19:32:50 GMT

I'm not sure what you want to do, but it still looks like a perfect candidate for SET ANALYSIS.

Can you upload some example/post some data?

Lukasz

Re: Set analysis issue for quarter

Thu, 06 Feb 2014 19:35:22 GMT

Sum(sales) range should be Q1 's last month in current year suppose in 2014 -march and Q3 last month suppose in 2013 September here in expression u have to add quarters as well for data.

regards

Mahesh

Re: Set analysis issue for quarter

preminqlik — Mon, 10 Feb 2014 06:02:42 GMT

i think according to your req , u have to caclulate last
months of current quarter ( Q1-2014) and last month of previous quarter (Q3-2013) ...didn't get you exactly what you mean...make excel and share results in that .....

Re: Set analysis issue for quarter

Mon, 10 Feb 2014 06:17:16 GMT

I hope the below discussion will help you:

Set Analysis - Quarter over Quarter Comparison

Thanks,

Angad

Re: Set analysis issue for quarter

manojkulkarni — Mon, 10 Feb 2014 06:18:56 GMT

as per your requirement, I think you are looking something like last 3 qtrs sales. Each qtr sales will be the sales for the last month of qtr. eg : Q1-2014 (March'14), Q4-2013(Dec'13) & Q3-2013(Sep'13)...