topic Re: Macro for sorting a chart in QlikView

Macro for sorting a chart

Fri, 18 Mar 2016 11:57:06 GMT

Hi,

I have some difficulties to sort a chart by an Expression. I want to sort the chart by Spends DESCENDING (Numeric Value: Descending). But I want to do this within a macro script, for a button action. And I don't know how exactly to do.

Can you give me some help regarding this, please ?

For example my chart has ID = 'CH01' and my expression is 'SpendEuro'.

Thank you,

Claudiu

Re: Macro for sorting a chart

MayilVahanan — Fri, 18 Mar 2016 12:03:48 GMT

Try like this

Sorting Macro | Qlik Community

Re: Macro for sorting a chart

marcus_sommer — Fri, 18 Mar 2016 12:04:10 GMT

If your sorting didn't work within the gui like you expected it you couldn't get it with a macro which could only apply the same methods and logics like within the object itself. Therefore you need to adjust your sort-expression and I think the reason why it didn't work is you didn't use an aggregation. You need something like: sum(SpendEuro).

- Marcus

Re: Macro for sorting a chart

Chanty4u — Fri, 18 Mar 2016 12:04:33 GMT

chk dis

Sort via Macro question

Re: Macro for sorting a chart

Fri, 18 Mar 2016 12:14:34 GMT

Is working using GUI but my chart is always 'generated' by a macro and is not keeping the GUI settings .

Re: Macro for sorting a chart

marcus_sommer — Fri, 18 Mar 2016 12:39:24 GMT

Yes, then have a look on the suggestion from Mayil whereby there are also possibilities for this without macros, like: User Controlled Charts In QlikView then (could be) Macros are Bad.

- Marcus