Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
bvssudhakar
Creator III
Creator III

Dual function is not working for combining two measures in Qlik sense

Hi People,

 

I have used Dual function to combine two expressions . here i am pasting 

Dual(SUM({$<Project_Id={$(vProjectId)}>}Budgeted_Project_Amount)& '/'&num(SUM({$<Project_Id={$(vProjectId)}>}Budgeted_Project_Amount)/SUM(total <Flag_Amount>{$<Project_Id={$(vProjectId)}>}Budgeted_Project_Amount),'##.##%'),SUM({$<Project_Id={$(vProjectId)}>}Budgeted_Project_Amount))

 

I am not understanding what is my mistake in this expression. Can you guys please have look on this and help me out from this

 

Note: Those two expressions working individually

 

Thank you in advance

Regards,

B V S S

3 Replies
Saravanan_Desingh

Can you try using single quote around the variable $(vProjectId)? Representing it as String.

'$(vProjectId)'

 

bvssudhakar
Creator III
Creator III
Author

Hi @Saravanan_Desingh ,

 

I have tried with quotes also but it's not working

 

@tresesco , @swuehl  Can you guys also please have a look into this

 

Thanks & Regards,

B V S S

swuehl
MVP
MVP

Can you explain a bit more detailed, what the problem is you see in your app?

What do you get and what do you expect to get?

Can you post a demo app or some screen shots?