Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

guya
New Contributor II

Chart with week & weekday as a dimension

Hi all,

I need to create a chart with week number and weekday as a dimension and two expressions counting the number of receipts (this and last year).

Pls find enclose a sample.

Does anyone have an idea

Thnks,

Guy

5 Replies
Not applicable

Re: Chart with week & weekday as a dimension

Click and drag your pivot table to get the layout how you want. See attached.

Not applicable

Re: Chart with week & weekday as a dimension

Also, if you wanted the grey formatting with 'Hol' for Holiday, you could do smthg like this.

guya
New Contributor II

Re: Chart with week & weekday as a dimension

Thx a lot Rebecca... that is very helpful

Any idea how to keep only business days (hide Sunday and Saturday) ?

I'm also trying to create a bar chart like on the sample2 but bars keep stacked even if I select 'Grouped' in the subtype style.

With many thanks

Guy

Not applicable

Re: Chart with week & weekday as a dimension

You can keep it to Mon-Fri by adding that to the set analysis. See attached.  For the bar graph you mentioned, what sample2 are you refering to?

guya
New Contributor II

Re: Chart with week & weekday as a dimension

Sorry, just uploaded it.

thx

Community Browser