Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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!