Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Prabhu
Contributor

Remove duplicate date on x axis bar chart

Hi All,

My bar chart dimension is displaying repeated MonthYear values. I want it to be displayed only unique MonthYear values.

Below is my chart dimension

=DATE(DATE#(Open_Time,'DD-MMM-YYYY'),'MMM-YY')

I tried this as dimension, but no use: Date(Floor(DATE#(Open_Time,'DD-MMM-YYYY')),'MMM-YYYY')

Please help

 

@sunny_talwar 

1 Reply
Partner
Partner

Re: Remove duplicate date on x axis bar chart

use monthstart function
change your dimension to
DATE(monthstart(DATE#(Open_Time,'DD-MMM-YYYY')),,'MMM-YY')