topic Re: Sorting Dimension by Date in QlikView

Sorting Dimension by Date

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

Hello all,

I have a chart where I have two dimensions, Business Case Number and Case Status, I want to see it ordered by date and what I'm currently doing is on the Sort tab under the Chart properties using the expression '=Date'

The issue is that I can't show label under the X-axis to see the dates, since my dimension is the Business Case Number, but I still need to see each individual case pm the chart, and if I use the Date as a Dimension it'll consolidate the ones that have the same one.

I thought of using a calculated dimension, but not sure how. Any ideas?

Thanks!

Re: Sorting Dimension by Date

agomes1971 — Tue, 05 Jun 2018 17:15:58 GMT

Hi,

please see this:

Hide a Dimension

HTH

André Gomes

Re: Sorting Dimension by Date

Anonymous — Wed, 06 Jun 2018 10:27:19 GMT

Hello André!

I don't want to hide it, I actually want to sow it, but not as business case, but as date.

Re: Sorting Dimension by Date

agomes1971 — Wed, 06 Jun 2018 10:35:55 GMT

Hi,

please attach a sample so I could help you.

Thanks

André Gomes