Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Why are the number of bars not equal to the number of month values?

Hi folks, How can I reduce the number of bars in the attached document to only show one for each month on the x axis instead of one for each date? Thanks for the help.

5 Replies
MVP
MVP

Re: Why are the number of bars not equal to the number of month values?

Hi,

Use Month as Dimension and expression as

=Sum(Sales)

Regards,

Jagan.

Not applicable

Re: Why are the number of bars not equal to the number of month values?

In the Script, you can create the New field MMMYY by using text(date(Date,'MMM YY'))

In the UI , the date values are different even though we interpret the format.

Not applicable

Re: Why are the number of bars not equal to the number of month values?

Thanks dathu, I can't use a text field because I want to show the axis values for 6 months interval. So the x axis of the chart will be Jan 2013, Jun2013, Dec 2013 etc.I guess I won't be able to accomplish this without using a date field.

Do you have any other suggestions?

Not applicable

Re: Re: Why are the number of bars not equal to the number of month values?

Please check the attached file....

MVP
MVP

Re: Why are the number of bars not equal to the number of month values?

Hi,

In Script arrive a new dimension like this

LOAD

     Date(MonthEnd(DateDimension), 'MMM-YY') AS MonthName,

     *

FROM DataSource;

Now use this as dimension and expression as Sum(Sales).

Regards,

Jagan.

Community Browser