topic Problems with Month dimension in QlikView

Problems with Month dimension

Thu, 12 Sep 2013 07:56:05 GMT

Hi guys,

I have a problem. I have a table that looks like that:

Order id orderdate deliverydate

11 2013.01.01 2013.05.01

12 2013.01.02 2013.01.29

13 2013.05.01 2013.05.25

I need to make a chart with month in dimension that would count orders and deliveries in month

I did that:

Month (orderdate) as month

Month (deliverydate) as month

But I get an error while loading data

Any suggestions?

Thanks in advance J

Re: Problems with Month dimension

michael_maeuser — Thu, 12 Sep 2013 07:59:07 GMT

you can´t load 2 fields with the same name.

try s.th. like that

Month (orderdate) as month

Month (deliverydate) as month2

the reason is you can either show your values by orderdate OR by deliverydate. but with example above you can create a cyclic dimension, so that you can switch between both dates

Re: Problems with Month dimension

abeyphilip — Thu, 12 Sep 2013 11:04:21 GMT

Hi,

Agree with Michael.

May be you can try something like being done in the attached the QVW.

regards,

Abey

Re: Problems with Month dimension

Anonymous — Thu, 12 Sep 2013 11:08:53 GMT

Hi,

Hope the attached excel and dashboard file will helpful for you

Regards

Ashok