Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team, I have created below model in power bi desktop. Is it possible same kind of model in Qlik Sense. If possible please give some idea. Thanks for your help.
You could something similar to below with the Multi-KPI visualization?
you could even swap the logo to the top - you can only use Unicode symbols though for your icons.
Use
//Dimension
=valuelist('Period','Policy Count','Claim Count','Gross Premium')
//Values by row
//Icons
if(valuelist('Period','Policy Count','Claim Count','Gross Premium')='Period',' - ',
if(valuelist('Period','Policy Count','Claim Count','Gross Premium')='Policy Count','📃',
if(valuelist('Period','Policy Count','Claim Count','Gross Premium')='Claim Count','📑',
if(valuelist('Period','Policy Count','Claim Count','Gross Premium')='Gross Premium','💸'))))
//Calculations
if(valuelist('Period','Policy Count','Claim Count','Gross Premium')='Period','MTD',
if(valuelist('Period','Policy Count','Claim Count','Gross Premium')='Policy Count',300,
if(valuelist('Period','Policy Count','Claim Count','Gross Premium')='Claim Count',320,
if(valuelist('Period','Policy Count','Claim Count','Gross Premium')='Gross Premium',120))))
Hi TM_burgers,
Thanks for you reply, could you post sample qlik sense qvd/qvm file. thanks for your help
Thanks
I have exported to a QVF if that helps.
Thank you so much