Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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

Tags (1)
3 Replies
Highlighted
Specialist III
Specialist III

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

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

'$(vProjectId)'

 

Highlighted
Creator II
Creator II

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

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

Highlighted
MVP
MVP

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

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?