topic Re: Bar chart with two Dimension and a Calculated Expression in QlikView

Bar chart with two Dimension and a Calculated Expression

Anonymous — Thu, 05 Nov 2015 16:39:17 GMT

Hi!

I ma trying to add a calculation inside a field using expression but couldn't get to it yet.

Here's what I am trying to do: On my last post (How to create another Column in script) I had created a "Table 3", now I would like to create a chart with those datas, using "date of maintenance" and "type of maintenance" as a Dimension and "=sum(US$)" as a expression. For now this is ok, but I would like to multiply an specific "type of maintenance" per a variable, for instance, as we look on the post there is a "type of maintenance" called yyy. I would like to take it and then multiply by 100.

Does someone have an idea on how do I get that?

Thanks in advance.

Re: Bar chart with two Dimension and a Calculated Expression

Gysbert_Wassenaar — Thu, 05 Nov 2015 17:13:29 GMT

You could add a mapping table to the script and then add a multiplier field to table3 that can be used to multiply the amount with:

MapMP:

Mapping Load * Inline [

Maintenance, Multiplier

yyy, 100

XXX, 80

ZZZ, 50

];

FinalTable:

LOAD *,

Date(Delivery + [Timeframe (Days)]) as [Date of Maintenance],

ApplyMap('MapMP',[Type of maintenance],1) as Multiplier

Resident Table;

DROP Table Table;

Re: Bar chart with two Dimension and a Calculated Expression

Anonymous — Thu, 05 Nov 2015 17:29:29 GMT

hi gysbert! Thanks for your answer.

In your example is good when you know all the values that will be multiplied. In my case, user will input the value and qlikview should calculate it.

Re: Bar chart with two Dimension and a Calculated Expression

Gysbert_Wassenaar — Thu, 05 Nov 2015 17:38:54 GMT

In that case you can try adding a new table with an Input Field

INPUT FIELD Multiplier;

Multipliers:

LOAD distinct [Type of Maintenance], 1 as Multiplier

Resident FinalTable;

Users can change the Multiplier values in a Table box with the two fields of the Multipliers table.

Re: Bar chart with two Dimension and a Calculated Expression

Anonymous — Thu, 05 Nov 2015 17:57:31 GMT

Ok!

but how can I pass the input variable in user interface to the "Multiplier"?