Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
May be this?
if(payment = 'Quarterly', [total device] * [price per unit] * 3)
Or
If(payment = 'Quantity', Sum([total device]) * Sum([price per unit] * 3)
how can I combine monthly with quarterly with yearly in 1 code
This?
If(Match(payment, 'Quarterly', 'Month', 'Yearly'), (Sum([total device]) * Sum([price per unit]) * 3))