topic Re: Bar Chart in QlikView

Bar Chart

bharatkishore — Mon, 09 Oct 2017 12:16:44 GMT

Hi All,

I am having a bar chart and there i am facing issue with the values.

The value what i am getting in text box is correct, but the value what i am getting in bar chart is wrong.

Can you please tell me where i am making wrong. For reference please find the attached app.

Thanks,

Bharat

Re: Bar Chart

sunny_talwar — Mon, 09 Oct 2017 12:26:21 GMT

What exactly are you trying to do here? Would you be able to elaborate a little?

Re: Bar Chart

bharatkishore — Mon, 09 Oct 2017 12:31:22 GMT

Hi Sunny,

I have to calculate sum(IB) for feb for example if i select jan IB value is sum(IB) and if i select feb the sum(IB) value is (Jan+Feb) and if i select march the sum(IB) is Jan + Feb + Mar. And this value i need to divide by month. If i select mar.. the output should be jan+Feb+Mar/3, if i select Feb month the output is Jan+Feb/2..

These one i need to achieve in bar chart.

Please let me know if you need anything more.

Thanks,

Bharat

Re: Bar Chart

bharatkishore — Mon, 09 Oct 2017 13:13:13 GMT

Hi Sunny ,

Please let me know if you need any more explanation or if i am not clear..

Thanks,

Bharat

Re: Bar Chart

sunny_talwar — Mon, 09 Oct 2017 13:33:45 GMT

Try this

Aggr(RangeAvg(Above(Sum({<MonthYear>}InstallBase), 0, RowNo())), Year, MonthName)

Where MonthName and Year are created like this

Fact_Cube_Data1:

LOAD MonthYear,

InstallBase,

[Strategic consumption]

FROM

(qvd);

BridgeTable:

LOAD DISTINCT MonthYear,

Year(MonthYear) as Year,

MonthName(MonthYear) as MonthName

Resident Fact_Cube_Data1

Order By MonthYear;

Re: Bar Chart

bharatkishore — Mon, 09 Oct 2017 13:50:44 GMT

Hi Sunny,

Sorry if i explained wrong , Please find below with better understanding:

Firstly in bar graph based on the month selection the number of bars should appear. If i select March i need to see 3 bars and if i select april i need to see 4 bars.. I have selected March and i can see 3 bars.

Now in expression i have given full accumulation and the values are correct till here. Now only the problem is i am unable to divide month wise.

The expression what i have given in a text box there the value is coming perfectly. The same expression when i am trying to put in bar chart the value is coming differently.

If we can get the same value in the bar chart which is as in same as text box means it resolves the issue.

Please find the attached app and please let me know if you require anything more.

Thanks,

Bharat

Re: Bar Chart

sunny_talwar — Mon, 09 Oct 2017 13:55:16 GMT

This?

Re: Bar Chart

bharatkishore — Mon, 09 Oct 2017 14:00:20 GMT

Thanks Genius, Thank u so much

This is what i needed. But i have one query is it possible to do without bridge table because the i have to change many things in my data and the data is huge.

Please let me know if we can do that way.

Thanks,

Bharat

Re: Bar Chart

sunny_talwar — Mon, 09 Oct 2017 14:03:16 GMT

Are you using QV12? If you are, then yes

Re: Bar Chart

bharatkishore — Mon, 09 Oct 2017 14:05:17 GMT

No QV 11... But is there anything wrong with my expression since the value is correct in text box and in chart it is wrong.

Can u pls tell me where i am doing wrong...

Thanks,

Bharat

Re: Bar Chart

sunny_talwar — Mon, 09 Oct 2017 14:12:00 GMT

Since there is no dimension and you are looking at just the value of a specific month, you are able to look at the correct value... but since you are looking to get the whole month... you will need to Inter-Record Functions

What you need is to make sure that the MonthYear field is sorted in ascending order and then you can create Year in your Fact table itself without needing to create a bridge table...

Re: Bar Chart

bharatkishore — Mon, 09 Oct 2017 14:15:50 GMT

Thank u genius .. Thank u so much...