Using Month and Monthname

[#1]

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

[#2]

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

[tobias_klett]

me neither

[#4]

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

[datagrrl]

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

[#6]

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

[datagrrl]

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.

[#8]

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

[ecolomer]

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