topic HOW TO CREATE QUARTERS in QlikView

HOW TO CREATE QUARTERS

Sun, 15 Nov 2015 20:54:08 GMT

I need to create A BAR CHART with 4 bars each represention Q1,Q2,Q3,Q4 respectively.

so If I select <=Mar , then I will see only 1 bar 'Q1', if I select for example May, I wanna see Bar for 'Q1' and bar for 'Q2' and so on.

I have Year and Month dimensions. How can I do that

Re: HOW TO CREATE QUARTERS

sunny_talwar — Sun, 15 Nov 2015 21:23:04 GMT

May be we can help you better if you can attach a sample?

Re: HOW TO CREATE QUARTERS

Sun, 15 Nov 2015 21:38:58 GMT

Here is sample Data

LOAD * INLINE [

Month, Type, Amount

Mar, Total Incurred, 28200

Jan, Total Incurred, 19200

Feb, Total Incurred, 5000

Apr, Total Incurred, 18000

May, Indemnity Incurred,12000

Jun, Indemnity Incurred, 13000

July , Indemnity Incurred, 9000

];

So If I Select Mar I wanna see Bar for Q1 with Jan, Feb and Mar Aggregated, and if I select Apr I wanna see Bar for 'Q1' and 2nd Bar for 'Q2'

Re: HOW TO CREATE QUARTERS

sunny_talwar — Sun, 15 Nov 2015 21:48:37 GMT

Something like this?

I used 2 dimensions, one is calculated dimensions

='Q' & Ceil(Month/3) and Type

Expression: =Sum({<Month = {"$(='>=' & 1 & '<=' & Max(Month))"}>}Amount)

Re: HOW TO CREATE QUARTERS

maxgro — Sun, 15 Nov 2015 21:49:13 GMT

see attachment

Re: HOW TO CREATE QUARTERS

Sun, 15 Nov 2015 23:07:52 GMT

Can you please attach a QVW?

Re: HOW TO CREATE QUARTERS

sunny_talwar — Sun, 15 Nov 2015 23:11:40 GMT

Both of us did

Open this link to find the attachment: Re: HOW TO CREATE QUARTERS

Re: HOW TO CREATE QUARTERS

Sun, 15 Nov 2015 23:19:49 GMT

In your script

load

'Q' & ceil((Month/3)) as Quarter;

load

Year(Date) as Year,

Month(Date) as Month;

load

makedate(2015, ceil(rand()*12)) as Date,

ceil(rand()*10) as Val

AutoGenerate 1000;

what is makedate(2015, ceil(rand()*12)) doing and I have multiple years, what is 2015 in there.

and I need the data to be cumulative, meaning,Q2, will be Q1 and Q2, and Q3 will be (Q1,Q2,Q3)

Re: HOW TO CREATE QUARTERS

sunny_talwar — Sun, 15 Nov 2015 23:23:02 GMT

I think your sample did not include year and date, so maxgro‌ must have created some dummy data for you to show the sample. If you can share a more representative sample (which include years) and stuff we might be able to get you a more relevant solution .

Also have you looked at my solution?

Re: HOW TO CREATE QUARTERS

Sun, 15 Nov 2015 23:36:23 GMT

in my case the Type is a Value List dimension so in the Expression I am using If

ValeuList (..........) -'Indemnity Incurred',

your expression, it doesnt work,

Re: HOW TO CREATE QUARTERS

sunny_talwar — Sun, 15 Nov 2015 23:38:46 GMT

Would you be able to share a sample because without a sample, we are just beating around the bushes.

Re: HOW TO CREATE QUARTERS

Mon, 16 Nov 2015 00:05:22 GMT

I dont know how to add the attachment to the Reply so I created the new discussion

Re: HOW TO CREATE QUARTERS

sunny_talwar — Mon, 16 Nov 2015 00:06:26 GMT

I see that new thread. I will work on getting a solution which might help

Re: HOW TO CREATE QUARTERS

Mon, 16 Nov 2015 00:14:24 GMT

Thanx Sunny

Re: HOW TO CREATE QUARTERS

maxgro — Mon, 16 Nov 2015 19:09:41 GMT

.qvw is already attached

script with test data is

load

'Q' & ceil((Month/3)) as Quarter;

load

Year(Date) as Year,

Month(Date) as Month;

load

makedate(2015, ceil(rand()*12)) as Date,

ceil(rand()*10) as Val

AutoGenerate 1000;

Re: HOW TO CREATE QUARTERS

Mon, 16 Nov 2015 19:29:30 GMT

Can you look at the actual QVW, QVD and Sample output . its under

"BAR CHART LINE ISSUE" thread