topic Re: Expression in QlikView

Expression

Mon, 28 Jan 2013 14:27:26 GMT

Hi,

I need to make a calculation in my dashboard.
Do I need to make an expression and what's the best possible solution for the following case.

ex.

Omschrijving Sum

------------------ -------

1. Verkopen 500

2. Indirect productiekosten 200

3. Directe kosten 100

4. Algemene kosten 500

Now I must calculate:

nettobedrag = sum(verkopen) - sum(indirect productiekosten)

bruto marge = nettobedrag - sum(Directe kosten)

I'm new and I don't know the syntax in QV.

Regards
Tim

Re: Expression

Mon, 28 Jan 2013 16:28:06 GMT

Hi Tim

look at att sample qvw file

Re: Expression

Tue, 29 Jan 2013 12:58:50 GMT

Thanks for the helpful answer, but

Omschrijving Sum

------------------ -------

1. Verkopen 500

2. Indirect productiekosten 200

3. Directe kosten 100

4. Algemene kosten 500

after the calculation it must be:

Omschrijving Sum

------------------ -------

Nettobedrag 300

Bruttomarge 100

4. Algemene kosten 500

Re: Expression

Tue, 29 Jan 2013 13:26:15 GMT

Hi,

You can either do it on Load process, with calculating it on the script side or in your chart with set analysis.

Could you plase share an example? Because you just put the numbers but to answer we need to know what based these numbers are? Are they monthly dimensioned or Order based?

Thanks