topic Re: Need help for Bar chart in QlikView

Need help for Bar chart

Fri, 07 Sep 2012 05:52:14 GMT

Dear All,

Below is my requirement

Month is Dimension

RM & PM are two values of field Catergory

I need Total of RM & PM as well

Month	PM	RM	Total
Apr-11	177	144	321
Apr-12	149	76	225
May-11	182	130	312
May-12	195	59	254

& I have to show it as follows

Please reply as soon as possible..its urgent

Thanks

Re: Need help for Bar chart

sreenivas — Fri, 07 Sep 2012 05:59:11 GMT

PFA file and click on the FASTCHANGE for Barchart and Table option

Re: Need help for Bar chart

Fri, 07 Sep 2012 06:22:22 GMT

Hi sreenivas,

Thanks for quick reply.

RM & PM are not 2 seperate fields,instead they are values of field category.

So how can it be achieve in this case?

& one more thing...month values will be coming dynamic..like current year current month selection gives me

these four monthname values

ie Current Year Current Month

Current Year Last Month

Last Year Current Month

Last Year Last Month

Based on these four I want to show RM & PM (which are field values of field Category) as well as Total values

Re: Need help for Bar chart

sreenivas — Fri, 07 Sep 2012 06:29:33 GMT

In Expression1;-Sum({<Category={'RM'}>} valuefieldname)

Expression2;-Sum({<Category={'PM'}>} valuefieldname)

Expression3=column(1)+column(2)

Re: Need help for Bar chart

sreenivas — Fri, 07 Sep 2012 06:33:38 GMT

Can u add the script for that file

Re: Need help for Bar chart

Fri, 07 Sep 2012 06:49:32 GMT

Hi sreenivas,

current year current month selection gives me
these four monthname values
ie Current Year Current Month
    Current Year Last Month
     Last Year Current Month
     Last Year Last Month

what about this??

Thanks.

Re: Need help for Bar chart

Fri, 07 Sep 2012 06:51:57 GMT

Not possible..since developement is done on client machine..& dont have permission to take the data

Re: Need help for Bar chart

sreenivas — Fri, 07 Sep 2012 06:52:44 GMT

Specify the date format of that datefield

Re: Need help for Bar chart

Fri, 07 Sep 2012 06:59:30 GMT

Date format will be DD/MM/YYYY

Month will be Monthname(MM-YYYY)

Re: Need help for Bar chart

sreenivas — Fri, 07 Sep 2012 09:07:25 GMT

Expression1:-- Sum({$<Category={'RM'}, Month={$(=Max(Month)),$(=Max(Month)-1)}, Year={$(=Max(Year)),$(=Max(Year)-1)}>}Value)

Expression2:-- Sum({$<Category={'PM'}, Month={$(=Max(Month)),$(=Max(Month)-1)}, Year={$(=Max(Year)),$(=Max(Year)-1)}>}Value)

Expression3:-Column(1)+Column(2)

Dimension-Month Year

Re: Need help for Bar chart

Fri, 07 Sep 2012 10:08:43 GMT

Hi sreenivas,

This is Exactly what i wanted..really appreciate your work

Thanks