Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Wording in formular

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

1 Solution

Accepted Solutions

Re: Wording in formular

I hope I understood your questions correctly.

1. sum(Umsatz_EUR_Kleffmann)*0.8

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


talk is cheap, supply exceeds demand
2 Replies

Re: Wording in formular

I hope I understood your questions correctly.

1. sum(Umsatz_EUR_Kleffmann)*0.8

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


talk is cheap, supply exceeds demand
Not applicable

Re: Wording in formular

Thank you very much!!

Community Browser