topic Insert Extra Data and Dimension Into a Chart in QlikView

Insert Extra Data and Dimension Into a Chart

Tue, 12 Mar 2013 08:03:25 GMT

Hi There,

Just wondering if there is a shortcut to this problem.

I have a pivot chart that calculates a bunch of things based on the transaction data.

That customer wants me to insert a line into the chart with a hardcoded amount.

Is there a tricky way to do this without having to add this data line to the loadscript and "taint" the rest of the data in the model with this value?

e.g.

Account 1, Sum(Amount)

Account 2, Sum(Amount)

Insert Value here: Hardcoded Account Name, 10,000

Total: 25,000

The calcs in the attached picture are pretty complicated and dynamic. The customer just wants me to insert a hardcoded value as a line.

Any ideas before I do it the hard way?

Thanks

Re: Insert Extra Data and Dimension Into a Chart

sushil353 — Tue, 12 Mar 2013 08:17:07 GMT

do u want to insert a dimension?

your requirement is not clear

Re: Insert Extra Data and Dimension Into a Chart

Sat, 16 Mar 2013 03:04:53 GMT

Hi There,

Yes you are right. The requirement is hard to express.

Basically I want to insert a dimension within the existing dimensions.

So just in that chart concatenate a dimension to the existing ones.

Is it possible to do that as some sort of aggregate or something?

e.g. AccountGroups

contains

Cleaning

Stationery

I want to add another dimension e.g. HiddenCosts but HiddenCosts is not in the AccountGroups load from the database.

I then want the chart to present all the AccountGroups + HiddenCosts as a dimension.

I can then in the expression say if Dimension = HiddenCosts then value = 10,000 else Sum(Amount)

Make sense?

Thanks