Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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