topic Charts in QlikView

Charts

Thu, 22 Mar 2012 04:07:37 GMT

Hi,

Am having a graph with y axis as hour of the day and x axis as weekday.

I need to plot the working hours(input from the user) in some different color.

say example: hourofday range is 0 to 23. working hours: 5 to 10, so 5 to 10 must be plotted in a different color(the plot areas background)

Please help me on this

Re: Charts

Mon, 26 Mar 2012 06:12:26 GMT

Hi,, Can anybody please help on this????

Re: Charts

jagan — Mon, 26 Mar 2012 06:33:00 GMT

Hi,

Hope the attach file helps you.

Can you attach the sample file.

Regards,

Jagan.

Re: Charts

Mon, 26 Mar 2012 07:30:50 GMT

Hi,

I need something like this:

If the wrking hours is from 10 to 18. The grid chart is already achievable we are now trying for the background.

Thanks

Charts

jagan — Mon, 26 Mar 2012 07:33:53 GMT

Hi,

Can you attach the sample file.

Regards,

Jagan.

Re: Charts

Thu, 29 Mar 2012 05:13:08 GMT

Please find the attached file.

Thanks

Re: Charts

kaushalview — Thu, 29 Mar 2012 07:42:26 GMT

Hi,

Try this Condition in Backgorund of HOUROFDAY dimension

if(HOUROFDAY>='00' and HOUROFDAY<='08',RGB(145,125,174))

Regards

Kaushal Mehta

Charts

Thu, 29 Mar 2012 08:27:32 GMT

This is not working in dimension nor in the background of colors tab nor reference lines in the presentation tab.

Please let me know where it should be placed

Re: Charts

jagan — Thu, 29 Mar 2012 11:19:17 GMT

Hi,

if(HOUROFDAY>='00' and HOUROFDAY<='08',RGB(145,125,174))

Paste this expression in the expression tab, click on the + icon to view the Background color expression textbox. Please refer the screenshot.

Hope this helps you.

Regards,

Jagan.