topic Re: Using Month and Monthname in QlikView

Using Month and Monthname

Mon, 15 Sep 2014 12:15:33 GMT

Hi,

I just happened to check on Month and MonthName functions in Qlikview wherein I got to see that when the value pertaining to a month is zero Monthname will show the name of the month that has the value greater than zero but the value remains unchanged when the particular month is being selected.For eg if jan has value 10 feb has 0, mar has 0,

when Month Feb is selected the chart displays month jan and value 0.

But the chart wherein Month(date) is used as Dimension the values are as expected and accurate.

So can anyone please explain as to why this is happening and how it could be overcome even when Monthname function is being used.

I have attached the document for reference

Re: Using Month and Monthname

Mon, 15 Sep 2014 12:56:30 GMT

I tried your document and i cannot see anything wrong .... i cannot reproduce the behavior you described

Re: Using Month and Monthname

tobias_klett — Mon, 15 Sep 2014 14:07:18 GMT

me neither

Re: Using Month and Monthname

Mon, 15 Sep 2014 14:17:35 GMT

your document is not opened because we are using personal edition . we cant open qlikview document in other machine in personal edition.the difference between month and monthname is month is displaying month only where as monthname display month and year

Re: Using Month and Monthname

datagrrl — Mon, 15 Sep 2014 16:55:21 GMT

I looked at your doc and was unable to reproduce your results.

Re: Using Month and Monthname

Tue, 16 Sep 2014 03:43:16 GMT

Please refer to the list box with the caption sum(MyValue)

Re: Using Month and Monthname

datagrrl — Tue, 16 Sep 2014 12:31:08 GMT

There is no list box with the Caption Sum(MyValue) in this version. There is a Chart(Straight Table) with that Caption.

Maybe if you could attach an image of this happening, because I have tried a number of things and the charts always display as expected.

Re: Using Month and Monthname

Wed, 17 Sep 2014 04:33:50 GMT

Hi,

Sorry its the chart that i was referring to please refer to the attachment wherein when the month Mar is selected from the list box highlighted chart dimension still shows up the month as January

Re: Using Month and Monthname

ecolomer — Wed, 17 Sep 2014 04:39:28 GMT

Your date format are:

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

and are correct the values showed