topic Sorting bar chart in QlikView

Sorting bar chart

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

hey all

my question is i have a bar chart with dimenssion monthyear but this field has dates since 2014

i need to show the dates on bar chart starting first of 2016 this means jan2016 and feb 2016 march2016

i formated the dimension as>> if(year>=2016,monthyear) ..this shows me feb2016 and jan2016 but as a descending feb the jan sorting even if i fix it on the sort tab on the chart ...i want to show ot as jan then feb .

hope anyone can help

‌

Re: Sorting bar chart

marcus_sommer — Tue, 15 Mar 2016 14:55:53 GMT

It's quite the same like this here: Chart sorting

- Marcus

Re: Sorting bar chart

MK_QSL — Tue, 15 Mar 2016 14:59:06 GMT

Go to sort tab.

Select monthyear and tick Expression

Write below expression

IF(monthyear >= YearStart(Today()),0,1)

Tick Numeric Value Ascending