topic cluster bars by arbitrary number (for readability) in QlikView

cluster bars by arbitrary number (for readability)

Wed, 16 Apr 2014 18:04:47 GMT

Hello. I have a bar chart with ~700 bars (please see attached). I would like to group them into groups (say of 10, or 25, or 50) to increase readability. I may cluster them in groups of n/10 to show deciles. Again, this is purely for ease of viewing.

From what I've read, clustering needs multiple dimensions. I tried adding a calculated dimension of =FLOOR(ROWNO(TOTAL),25) in order to get them into groups of 25. This formula doesn't calculate when it's a dimension. It works perfectly when I use it as an expression, but then I cannot use it for defining bar clusters.

Any suggestions?

For what it's worth, I'm much more comfortable on the scripting side of things rather than the layout/visualization side of things, so I apologize if this is an easy one that I'm missing!'

Thanks.

Re: cluster bars by arbitrary number (for readability)

Thu, 24 Apr 2014 03:42:53 GMT

bumping this in the hopes that someone has a suggestion

Re: cluster bars by arbitrary number (for readability)

jagan — Thu, 24 Apr 2014 04:03:21 GMT

Hi,

Can you attach the sample? Try Class().

Regards.

Jagan.

Re: cluster bars by arbitrary number (for readability)

sundarakumar — Thu, 24 Apr 2014 06:29:54 GMT

I would suggest a script level calculated dimension would work fine in this case.

1. create a field while loading the data as

ceil(rowno()/25) as clusters

2. when u reload u get a new field called "clusters" with value "1" for first 25 values, "2" for the next 25 and so on till the last row in ur table...

3. use this cluster as the dimension. in the bar chart..

4. u may even bucket them with some business rules like ascending order of sales(which can be done with a order by in scripting)

Hope this helps.

-Sundar

Re: cluster bars by arbitrary number (for readability)

Tue, 29 Apr 2014 19:42:05 GMT

Sundar,

Unfortunately, the bars below are calculated on the fly by taking value/average(other related values). The linkage is actually by a synthetic key that was formed using intervalmatch. Without destroying the intervalmatch-created bridge table, I can't flatten my data structure to the point where I can push the cluster number into the script (and thus, into the fact table).

I've basically given up on this... it doesn't look supported in Qlikview unless you can let the script do the heavy lifting.

I don't urgently need a solution; I'll leave this question marked unanswered in the hopes that a future QV release supports "arbitrary clustering".

Thanks!

Re: cluster bars by arbitrary number (for readability)

sundarakumar — Wed, 30 Apr 2014 02:26:51 GMT

Please post a sample app in which u r facing the problem, so that we can try to find a solution.

-Sundar