topic Re: Barchart with three dimension in QlikView

Barchart with three dimension

Wed, 07 Aug 2013 08:27:46 GMT

Hello,

I'm trying to make a stacked barchart with 3 dimensions. Month, week country, and as expression the distinct count of orders.

I almost have it, but now I'm stuck with a little problem between the month and week dimension.

At the moment he shows per month all the weeks possible, but i want to show only the weeks of that month.

I've added a picture to clarify. In this picture i filtered down to 2 months. As you can see, in the first month i have 10 week, with only data for 5 weeks. The weeks from that month. In the other month the same. I dont want those empty weeks.

How can I change this?

Thx in advance!

Re: Barchart with three dimension

tresB — Wed, 07 Aug 2013 08:31:42 GMT

Check 'Suppress When Value is Null' in Dimension tab. Check- 'Suppress Zero Values', 'Suppress Missing' in presentation tab.

hope that helps

Re: Barchart with three dimension

Wed, 07 Aug 2013 08:39:44 GMT

Hi Tres Qv,

thx for the quick reply. I tried it, but it doesnt seem to change anything.

I've added the qvw, maybe i did something wrong.

Thx!