topic Re: CHART ISSUE in QlikView

CHART ISSUE

Mon, 16 Nov 2015 00:04:14 GMT

Here is the sample data, I am trying to create a chart with the following Calculated dimension and I am using the value list function to create the dimension

. My valueList is ('Incurred ','Paid')

. Incurred = Sum(Ind Paid-Ind Rec) and Paid =(Ind Paid+ Exp Paid)

I am using Two Diemsions in the Bar chart

1st one is

$(vValuelist)and second is 'Q'& Ceil(Month/3)

I wanna calculate the Incurred and Paid for each Quarter represented by Bars, for example If I select <= 'Mar' I should see the Bar for Q1 for Incurred and Paid seperatley

If Month > Mar and <= Jun' then I expect to see Bar 'Q1' and Bar 'Q2' again for both Incurred and Paidand so on. and Q2 includes Q1 and Q2, Q3 includes (Q1,Q2 and Q3), its all cumulative.

Please let me know if this good enough info.

Attached is the real Sample data

Re: CHART ISSUE

sunny_talwar — Mon, 16 Nov 2015 00:13:25 GMT

See if the attached sample makes sense:

Script:

Table:

LOAD *,

MakeDate(Year, Month, 1) as Date,

MonthName(MakeDate(Year, Month, 1)) as MonthYear;

LOAD Year,

Month(Date#(Month, 'MMM')) as Month,

[IND PAID],

[EXP PAID],

[IND REC],

[EXP REC];

LOAD Year,

Month,

[IND PAID],

[EXP PAID],

[IND REC],

[EXP REC]

FROM

Sample_Data_Quarters.xls

(biff, embedded labels, table is Sheet1$);

Dimensions

1) ='Q' & Ceil(Month/3)

2) =ValueList('Incurred', 'Paid')

Expression

=If(ValueList('Incurred', 'Paid') = 'Incurred', Sum({<Month = {"$(='>=' & 1 & '<=' & Max(Month))"}>}[IND PAID] - [IND REC]), Sum({<Month = {"$(='>=' & 1 & '<=' & Max(Month))"}>}[IND PAID] + [EXP PAID]))

Re: CHART ISSUE

Mon, 16 Nov 2015 00:23:54 GMT

I want the chart to look like this in a Trellis Chart option. The circles are expected values. Which I can add once I figure out the bars

Re: CHART ISSUE

sunny_talwar — Mon, 16 Nov 2015 00:27:53 GMT

Close?

Re: CHART ISSUE

Mon, 16 Nov 2015 00:28:30 GMT

Why do you have 3 Load Statements?

Re: CHART ISSUE

sunny_talwar — Mon, 16 Nov 2015 00:31:48 GMT

Just to make sure that Time data (Month and date) are read as dual field else the set analysis won't work properly. I am guessing those steps would not be required for your actual data if you have Month field created from your date field like this -> Month(DateField) as Month

Re: CHART ISSUE

Mon, 16 Nov 2015 00:35:55 GMT

Yes it is already created , so I dont need any changes to the script the, but I tried the expression , not the same result as yours

Re: CHART ISSUE

Mon, 16 Nov 2015 00:37:10 GMT

Th is exactly what I am looking for . How did you do it? do u have a QVW for that and just to make sure, I dont need to make any change to the script?

Re: CHART ISSUE

sunny_talwar — Mon, 16 Nov 2015 00:38:11 GMT

Do you have MasterCalendar in your script? Can you share the code you are using for your Master Calendar?

Re: CHART ISSUE

sunny_talwar — Mon, 16 Nov 2015 00:39:33 GMT

Attached here: Re: CHART ISSUE

Re: CHART ISSUE

Mon, 16 Nov 2015 00:40:05 GMT

I dont have master Calendar in my script,

Re: CHART ISSUE

Mon, 16 Nov 2015 01:38:48 GMT

Any more sugestions??

Re: CHART ISSUE

sunny_talwar — Mon, 16 Nov 2015 01:43:01 GMT

The attached sample did not help you achieve what you were looking for?

Re: CHART ISSUE

Mon, 16 Nov 2015 01:52:40 GMT

No my results dont work, in my case I am not getting two bars, If I select <= Mar I get Q1 but when I select Apr I only get Q2, I wanna seee both Q1 and Q2 like your qvw

Re: CHART ISSUE

Mon, 16 Nov 2015 01:54:03 GMT

and I dont have master calendar in my script

Re: CHART ISSUE

sunny_talwar — Mon, 16 Nov 2015 01:56:41 GMT

Did you try this in your set analysis?

{<Month = {"$(='>=' & 1 & '<=' & Max(Month))"}>}

How is MonthField created? Can you share where you have Month created?

Re: CHART ISSUE

Mon, 16 Nov 2015 02:14:23 GMT

Yes I am using the same expression

and I am calculating the month as

Month(Date#([As of],'YYYYMM')) As Month

cuz [As Of] is in 'YYYYMM' format

Re: CHART ISSUE

sunny_talwar — Mon, 16 Nov 2015 03:41:08 GMT

That is very strange, I am not sure why it wouldn't work for you if it is working in the attached application.

Re: CHART ISSUE

Mon, 16 Nov 2015 15:45:06 GMT

I have started a new thread called "BAR CHART WITH LINE ISSUE"

and have attached the actual QVD, Dashboard and the issue description with the Image. Can you please look into it

Re: CHART ISSUE

Tue, 17 Nov 2015 02:00:47 GMT

Can you pls help me with my Bar Chart issue