if else function

[Anonymous]

I have 1 table for companies, 1 table for payments periods, and I have text box containing total amount of payment per period as below:

so if i select  client which is pays monthly, QlikSense should view only monthly payment. and hide other periods.

for example:

if(payment = 'Quarterly'), ([total device] * [price per unit] * 3)

[Anil_Babu_Samineni]

May be this?

if(payment = 'Quarterly', [total device] * [price per unit] * 3)

Or

If(payment = 'Quantity', Sum([total device]) * Sum([price per unit] * 3)

[Anonymous]

how can I combine monthly with quarterly with yearly in 1 code

[Anil_Babu_Samineni]

This?

If(Match(payment, 'Quarterly', 'Month', 'Yearly'), (Sum([total device]) * Sum([price per unit]) * 3))