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

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
cancel
Showing results for 
Search instead for 
Did you mean: 
Vijaydurga
Contributor II
Contributor II

Number function not applying in below chart is there any error in code can you please check why number function not applying below chart

=pick(WildMatch(Vcurrency,1,2,3),num(sum(Sales_INR)/1000,'₹#,###.0' &' '& 'K'),
num(sum(Sales_EUR)/1000,'€#,###.0' &' '& 'K'),
num(sum(Sales)/1000,'$#,###.0' &' '& 'K'))

Vijaydurga_0-1637514982502.png

 

 

1 Reply
abhijitnalekar
Specialist II
Specialist II

Hi @Vijaydurga ,

You have converted the number in the string in the formula by adding 'K'  and ₹ while formating the number

 

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!