topic Re: Problem with (Week and Date) as Dimensions in Bar chart in QlikView

Multidimensions: Problem with (Week and Date) as Dimensions in Bar chart

geam1988 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am using bar Chart, 3 Dimensions and 1 Expression.

I want to show Week and Date as Dimensions on X-axis and Mateial is also Dimension but on Y-Axis . My chart is showing Week and Date as Dimensions on X-axis but Date is not accurate as per week. It is showing additional date.

How can i show respective date as per week? I want to show all date of that particular week( even there is no quantity available).

Please see the QVW file.

Thanking You

Kazi

Re: Problem with (Week and Date) as Dimensions in Bar chart

Vegar — Sun, 19 Apr 2020 19:35:29 GMT

I don't think what you want is possible as you want. An alternative solution is to swap date with weekday. IS this an alternative that will meet your needs?

Re: Problem with (Week and Date) as Dimensions in Bar chart

geam1988 — Mon, 20 Apr 2020 07:32:12 GMT

Hi Vegar, I need to show either date (24.04 or 24.04.2020) or Day (24). Why is it not possible? Is there any logical reason? Thanks

Re: Problem with (Week and Date) as Dimensions in Bar chart

Vegar — Mon, 20 Apr 2020 09:03:22 GMT

It is not considering this as a hiearchy,but presenting all combinations. Compare to what happens if I switch the date and week combination.