Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
cbaqirdhds
Valued Contributor

Month/Year repeating and Sort

I know I have run into this before and suspect I need to do something like add another dimension in my AGGR statement but I can't figure out what is happening...

I want the months in the Readmits per Month line chart to show Jul 2013, Aug 2013, Sept 2013 etc but Jul 2013 shows up multiple times etc with the dimension of =date(ADMIT_DATE, 'YYYY-MMM')

Any ideas?

Tags (3)
1 Solution

Accepted Solutions

Re: Month/Year repeating and Sort

Try this

=Date(MonthStart(ADMIT_DATE), 'YYYY-MMM')

3 Replies

Re: Month/Year repeating and Sort

Try this

=Date(MonthStart(ADMIT_DATE), 'YYYY-MMM')

cbaqirdhds
Valued Contributor

Re: Month/Year repeating and Sort

There are no data points in the line graph?

Re: Month/Year repeating and Sort

I saw that too... can you create a field in the script instead of using a calculated dimension and use that in your aggr() expression?