This content has been marked as final. Show 3 replies
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.
if(payment = 'Quarterly'), ([total device] * [price per unit] * 3)