topic Re: Bar display one-on-one in QlikView

Bar display one-on-one

jagannalla — Thu, 06 Sep 2012 07:28:48 GMT

Hello,

I've a table with fields Date and value. I want to display the sum of the value based on dimension date(i.e. first half one part, second half another part).

For eg:

Jan-Aug->4000

Sept-Dec->2000

Jan-Dec ->6000

The chart should look like this:

- The blue color shows data of value from jan to aug, red from sept to dec. Green shows entire data for 2012.

How can i achive this.

Re: Bar display one-on-one

Jason_Michaelides — Thu, 06 Sep 2012 08:37:30 GMT

Please post your app.

Re: Bar display one-on-one

jagannalla — Thu, 06 Sep 2012 08:44:41 GMT

Please check enclosed app.

Re: Bar display one-on-one

Jason_Michaelides — Thu, 06 Sep 2012 09:11:25 GMT

How's this?

Re: Bar display one-on-one

Jason_Michaelides — Thu, 06 Sep 2012 09:15:15 GMT

Slight adjustment to the dimension names...

Re: Bar display one-on-one

jagannalla — Thu, 06 Sep 2012 09:27:45 GMT

I find the solution in best way i think so. Please check the file once.

Re: Bar display one-on-one

rajni_batra — Thu, 06 Sep 2012 09:31:24 GMT

i have never used the function valuelist & didnt even find Qv help. can u explain y we use this

Re: Bar display one-on-one

Jason_Michaelides — Thu, 06 Sep 2012 09:31:46 GMT

Your script is only using Month() therefore the same months in different years will be grouped together:

If(Year(DateField)=Year(Today()),'Actual/Projected') as "Actual/Projected",

If(Month(DateField)*1<$(vCurrentMonth),'Actual','Projected') as FleetCapacity,

Maybe try:

LET vCurrentMonth= Today();

If(Year(DateField)=Year(Today()),'Actual/Projected') as "Actual/Projected",

If(DateField<$(vCurrentMonth),'Actual','Projected') as FleetCapacity,

Re: Bar display one-on-one

Jason_Michaelides — Thu, 06 Sep 2012 09:32:18 GMT

It's in the help - look for "Synthetic Dimensions"