topic Grid chart custom sorting with dynamic dimensions (via variables) in QlikView

Grid chart custom sorting with dynamic dimensions (via variables)

Fri, 25 Sep 2009 22:36:49 GMT

Hi Guys, I got a grid chart which I'm trying to get a custom sort working, but since I use dynamic dimension (via variables), it doesn't.

Looking at my little model (see attached QVW), you can see that it's working with static dimensions (right grid chart), but not with dynamic ones (left grid chart).

Is there a way to make this work?

Thanks a bunch!

Grid chart custom sorting with dynamic dimensions (via variables)

Fri, 25 Sep 2009 23:10:27 GMT

You forgot to attach the QVW.

I ran into this problem when using a calculated dimension and sort by expression. Sort by expression does not work when your chart contains calcuated dimensions.

When I ran into this problem, I found a way to calculate the dimension in the load script and then I could use a standard dimension on the chart.

Grid chart custom sorting with dynamic dimensions (via variables)

Fri, 25 Sep 2009 23:38:49 GMT

Woops! Thanks for getting me back to order... ahah. Here is the QWV.

Hmm, if what you're saying Miller is the down truth of Qlikview right now... it's unfortunate. The idea is to let the end-user play with the dimension, one solution that come to mind would be to create 2 grid chart with displaying conditions... but still that's not very elegant.

Btw, do hidden charts get calculed?

And Thanks for your reply Miller. 🙂

Grid chart custom sorting with dynamic dimensions (via variables)

Sat, 26 Sep 2009 01:02:11 GMT

I took a quick look at the functionality of your QVW. The dynamic dimension is causing the Sort By Expression to turn off.

Since you're basically trying to allow the user to select the dimensions, you may be able to use a Cyclic group (Page 469 of Book III in the Reference Manual - 23. Field Groups). That allows you to define multiple dimensions and let the user pick which one they want to use. I am not sure if that will play nice with the Sort By Expression though. I haven't ever used it on a Grid Chart, but it seems to be available, so I would give that a shot.

Grid chart custom sorting with dynamic dimensions (via variables)

Sat, 26 Sep 2009 01:11:17 GMT

Hmm heh, well, that's the first I should have mention. I have a picky customer here.

They apparently don't like the cycle, go figure. But thank for the suggestion.

Grid chart custom sorting with dynamic dimensions (via variables)

Sat, 26 Sep 2009 01:32:46 GMT

I'm not surprised. Customers never seem to like any built-in features.