Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

kashjaniqlik
New Contributor III

Sorting by a different column on bar chart

Hello

I have a bar chart which shows a count of a number (some issues that we have in business) on Y Axis by Month and Year on X Axis.

The month & year is derived by a date (Issue start date) during the script load and this month & year is shown on x axis. I would like to sort the bar chart by the original column (Issue Start date) rather than the derived column (Month & Year).

I have been trying to sort the chart using the Issue start date in the expression field of Sort tab but it doesn't seem to work. If I'm able to do this then the chart will be properly sorted by issue start date and so will be the derived column on the x axis.

Any help will be great.

Many Thanks

1 Solution

Accepted Solutions

Re: Sorting by a different column on bar chart

Create your MonthYear field as a date with the display format you want. For example as date(monthstart([Issue Start date]),'MMMM YYYY') as MonthYear


talk is cheap, supply exceeds demand
2 Replies

Re: Sorting by a different column on bar chart

Create your MonthYear field as a date with the display format you want. For example as date(monthstart([Issue Start date]),'MMMM YYYY') as MonthYear


talk is cheap, supply exceeds demand
kashjaniqlik
New Contributor III

Re: Sorting by a different column on bar chart

That's Great. Thanks Gysbert.

Community Browser