topic Re: urgent help[ required in bar chart in QlikView

urgent help[ required in bar chart

Thu, 12 Jun 2014 03:54:53 GMT

Hi All,

I'm having a bar chart X- axis of this chart is date in MMM_YYYY format.

There are more than one entry in single month so chart has to sum up these things and have only one bar for one month. Currently chart is having more than one chart for each month as there are more than one record for each month. But how do i make it to show one bar per month ?

Attached is sample file.

Thnaks

Re: uugent help[ required in bar chart

senpradip007 — Thu, 12 Jun 2014 03:58:54 GMT

Can you upload sample qvw?

Re: urgent help[ required in bar chart

Thu, 12 Jun 2014 04:16:47 GMT

Hi Pradip,

PFA file.

Re: urgent help[ required in bar chart

kamalqlik — Thu, 12 Jun 2014 04:45:05 GMT

Hi Kavita,

I am not able to get what you want.

Can you explain it more clearly as per your requirement.

Regards,

Kamal

Re: urgent help[ required in bar chart

Thu, 12 Jun 2014 04:58:54 GMT

Hi Kamal,

I had uploaded wrong file. Now I have changed it. If u open the file I shared now, You can see multiple bars for Dec-2012. All I want is have single bar for Dec-2012(or have single bar for every month).

Re: urgent help[ required in bar chart

kamalqlik — Thu, 12 Jun 2014 05:09:37 GMT

Hi Kavita,

Please attach the file to.

Re: urgent help[ required in bar chart

Thu, 12 Jun 2014 05:12:08 GMT

Hi Kamal,

I have attached the updated file . Please see my previous comments

Kavita

Re: urgent help[ required in bar chart

senpradip007 — Thu, 12 Jun 2014 05:46:04 GMT

Try somthing like:

Aggr(sum( BILLED_AMT1), MONTH_BILLED)

Re: Re: urgent help[ required in bar chart

tresB — Thu, 12 Jun 2014 05:57:14 GMT

Remove your group as dimension and take Billed_Month as dimension. PFA

Re: urgent help[ required in bar chart

jagan — Thu, 12 Jun 2014 06:00:23 GMT

Hi,

Give this as expression in your Drill down Group

=Date(MonthEnd(MONTH_BILLED), 'MMM-YYYY') instead MONTH_BILLED.

or Create a new field in script like below and use it in Drilldown group

LOAD

Date(MonthEnd(Date#(BILLED_MONTH,'DD-MMM-YY')), 'MMM-YYYY') as BILLED_MONTH

From DataSource;

Hope this helps you.

Regards,

Jagan.