Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Singaravelu_R
Contributor III
Contributor III

Clarification related to Visual

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.

Singaravelu_R_0-1631012818223.png

 

4 Replies
tm_burgers
Creator III
Creator III

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))))

 

 

3ae8c6d4ad004f67a400683d6ebf507a.jpg

Singaravelu_R
Contributor III
Contributor III
Author

Hi TM_burgers,

Thanks for you reply,  could you post sample qlik sense qvd/qvm file. thanks for your help

 

Thanks

tm_burgers
Creator III
Creator III

I have exported to a QVF if that helps.

 

Singaravelu_R
Contributor III
Contributor III
Author

Thank you so much