topic Re: Bar chart > bar with second pattern? in QlikView

Bar chart > bar with second pattern?

Tue, 07 Aug 2012 10:00:54 GMT

Hello QVer,

in a bar chart I want to visualisize a "Sunday"-bar in red colour; when Sunday is also an official holiday the bar should get a second pattern, frame etc.

Is that possible? How? Thanks. Greetings

Re: Bar chart > bar with second pattern?

Tue, 07 Aug 2012 10:21:05 GMT

could it be two separete colors (holiday - sunday)?

try to paste in expression background

=if(Date='2012-01-01' or Date='2012-01-06',red(),if(WeekDay(Date)=6,lightred()))

* you should list all the dates that are holidays in your country

Re: Bar chart > bar with second pattern?

Tue, 07 Aug 2012 11:05:31 GMT

Hello and thanks.

I've already done making those days red which are holidays.

Now I want to have all Sun- and Saturdays with a pattern and background coloured (i.e. red) when those days are official holiday. It should look like:

Greetings .

Re: Bar chart > bar with second pattern?

Fri, 10 Aug 2012 07:00:55 GMT

Hello,

any idea to assign two attributes to a bar of a bar chart as seen in my former posting?

Should mean i.e.: day is sunday (coloured red) and official holiday (pattern).

Thanks.Regards.

Re: Bar chart > bar with second pattern?

Fri, 10 Aug 2012 07:18:57 GMT

i'm afraid it is imposible:/

why dont you choose suitable colours

i mean....

lightred for sundays

colormix (lightred, darkgrey) for holidays

Re: Bar chart > bar with second pattern?

Fri, 10 Aug 2012 07:41:23 GMT

Thanks "Pari Pari".

I missed the "impossible" statement in your former Posting.

So I will try the colormix.

Regards.