topic Wording in formular in Qlik Learning Discussions

Wording in formular

Wed, 24 Sep 2014 09:14:50 GMT

Hi,

I have two questions about the right formula in QlikView:

1: If I want to calculate 20 % less for the following formula, what´s the right wording:

sum(Umsatz_EUR_Kleffmann)

2: We have a source with a Price list. The wording for the Price is

only(ppr_preis) here I can see the Price for the actuall year

I want to show the price for the following year (Price for 2015 in 2014). What`s the right wording?

Thanks for your answers.

Ulrich

Gysbert_Wassenaar — Wed, 24 Sep 2014 12:02:35 GMT

I hope I understood your questions correctly.

1. sum(Umsatz_EUR_Kleffmann)*0.8

2. only({<Jahr={2015}>}ppr_preis)

Wed, 24 Sep 2014 13:11:52 GMT

Thank you very much!!