"Ungrouping" sum - a separate line per additional dimension

[Luk_B]

Hi,

This is probably very simple and I saw it before, but forgot how to do that and don't want to spend ours on figuring that out.

I have a table where I need an additional calculated dimension (Clusters) and conditional name would be depending on volume AND value in measures.

Let say if Volume is > 10000 AND Value > 0, then it would be Cluster 1, if condition is not met then Cluster 2

So let say that calculated dimension works (aggr by Account Numer) and I get something like below:

What I need is to show 3 lines with Account number column removed from the table

This is incorrectly creating Cluster 2 anyway because the calculated dimension is using aggr per account number.

Thanks,

Luke

[QFabian]

Hi @Luk_B , in this example, the column doesnt dissapears, but at least doesnt show neither the title or the account numbers

[Luk_B]

Hi Fabian,

Thanks a lot you even took the effort to replicate that.

The purpose of this was to create a table which would be used in the mashup to create a custom scatter chart and I wanted to give a "clean" table to the web guy, so he has accounts grouped in Clusters depending on some predefined volumes, values, but don't show the account name.

I remember there is a trick (and not sure who presented that - maybe S Dark), that you can force the chart to not group calculations by dimension (by forcing use of another dimensions in the background) and can't remember what was needed to do that - rank or sorting...

Hiding with color doesn't solve it exactly. I will give the table to the web guy and see if its ok for now.

But even if I wanted to use Qlik scatter chart with custom cluster dimension I am not able to do so without removing account id

Thanks,

[QFabian]

Ok no problem!, do you know about hypercubes to make advanced mashups and just give the data to paint another chart?

[Luk_B]

HI, Yes I know there can be just custom parts of the Q object taken, so web guys can do a lot with that...