Discussion board where members can get started with QlikView.
Need help in create below two KPI's
First KPI : column b 123 has amount $10 and 444 has $40 i just need to pick distinct value of col b and there respective amount to be sum $10 +$40 = 50 this should be my KPI result
Second KPI : I need distinct count of col b = 2 should be my KPI result
KPI1 : Sum(Distinct ColC)
KPI2 : Count(DISTINCT ColB)
View solution in original post
Thank you for quick response