topic Re: Sort Order in Graph in QlikView

Sort Order in Graph

shamitshah — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a calculated dimension as =If([Fiscal Year] < Year(Today()) or [Fiscal Year] > Year(Today()), [Fiscal Year],[Fiscal Period]) .

I am not able to get the correct sort order in a bar chart (see below). I am trying to show ascending Fiscal Years for prior years and the by Fiscal Period the current year (2017).

Any idea on how I can achieve the correct sort order - ascending by Fiscal Year and Fiscal Period?

Thanks

Re: Sort Order in Graph

Anil_Babu_Samineni — Mon, 03 Jul 2017 02:31:55 GMT

You are calculating the [Fiscal Year] and seems you used Period if filter not happens. Can we know the reason or intend to show. Could be the reason Period field. Or can you enable all options from Sort tab and promote the calc. dim if it not in first place from Sort tab

Re: Sort Order in Graph

vinieme12 — Mon, 03 Jul 2017 06:22:10 GMT

Check this out

Period Presets: Compare Periods on the fly

Re: Sort Order in Graph

shamitshah — Tue, 04 Jul 2017 00:34:31 GMT

Hi,

I used the following and it seems to be working fine:

Sort by Expression using Fiscal Year, followed by Numeric Value

Thanks all.