topic Re: Pivot Chart - Dimension Expression Header/Level Change & Sorting in QlikView

Pivot Chart - Dimension Expression Header/Level Change & Sorting

Thu, 09 Apr 2015 08:49:26 GMT

Hello There!

I need a solution for to change the Dimension Expression Header/Level for Pivot Chart and as well as Sorting the Dimension Expression as per the Value. How can I achieve that?

I'm posting here a snap-shot of my current Pivot Chart for your ready reference and suggestion.

Thanks in Advance.

Sajjad Ali.

Re: Pivot Chart - Dimension Expression Header/Level Change & Sorting

pokassov — Thu, 09 Apr 2015 09:01:11 GMT

Hi!

Re: Pivot Chart - Dimension Expression Header/Level Change & Sorting

Thu, 09 Apr 2015 11:17:31 GMT

Hello!

Thanks for your suggestion/solution.... Actually I found the Level check-box was dimmed (Disabled); however it works fine.

Can you please suggest regarding 'Sorting the Dimension Expression as per the Value. How can I achieve that?'

Thanks & Regards,

Sajjad.

Re: Pivot Chart - Dimension Expression Header/Level Change & Sorting

pokassov — Thu, 09 Apr 2015 11:31:09 GMT

1. Tab "Sort"

2. Select Dimension that you want to sort

3. Check box "Expression"

4. Put you expression there

5. Uncheck boxes "Numeric Value",'Text'