Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
jagan
Luminary Alumni
Luminary Alumni

Hi,

Use Month as Dimension and expression as

=Sum(Sales)

Regards,

Jagan.

Not applicable
Author

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
Author

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
Author

Please check the attached file....

jagan
Luminary Alumni
Luminary Alumni

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.