Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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
saran7de
Master
Master

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

'$(vProjectId)'

 

bvssudhakar
Creator III
Creator III
Author

Hi @saran7de ,

 

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?