
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can we use Dual() to combine two measures ?
Hello everyone,
I have a requirement where I have to show multiple measures in a line chart on a single axis. My current data is monthwise Sales and Target
Month | Sales | Target |
Apr | 185 | 95 |
May | 56 | 95 |
June | 0 | 95 |
July | 0 | 158 |
Aug | 0 | 158 |
Sep | 0 | 158 |
Oct | 0 | 375 |
Nov | 0 | 182 |
Dec | 0 | 182 |
Jan | 0 | 201 |
Feb | 0 | 201 |
Mar | 0 | 296 |
Now I have to calculate another measure Achievement% using sales and target formula for the same is (Sales/Target)*100 and show this measure besides Sales data point label on the same axis
Current Representation:
Required representation:
Any help would be appreciated.
Regards,
Aditya
- Subscribe by Topic:
-
Chart
-
dimension
-
expression
-
Qlik Cloud
-
Set Analysis
-
Visualization
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for your reply but the issue got resolved after changing the number formatting of my measure to "measure expression".
Regards,
Aditya

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Like this:
Dual(Sum(Target)&
If(Sum(Sales)>0,'(' &Num(Sum(Sales)/Sum(Target), '##.#%')&')')
, Sum(Target))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have used same method. But % values are not showing in bracket besides Sales values.
Expression used:
Dual(
Sum({<DATE={">=$(=Date(YearStart(max(DATE),0,4)))<=$(=Date(monthend(yearstart(max(DATE),0,4))))"}>}Agreement_Value__c)
&
if(
(Sum({<DATE={">=$(=Date(YearStart(max(DATE),0,4)))<=$(=Date(monthend(yearstart(max(DATE),0,4))))"}>}Agreement_Value__c))>0
,
'(' &
num(
Sum({<DATE={">=$(=Date(YearStart(max(DATE),0,4)))<=$(=Date(monthend(yearstart(max(DATE),0,4))))"}>}Agreement_Value__c)
/
Sum({<DATE={">=$(=Date(YearStart(max(DATE),0,4)))<=$(=Date(Monthend(yearStart(max(DATE),0,4))))"}>}[AOP Target])
,'##.#%' &')'
)
)
,
Sum({<DATE={">=$(=Date(YearStart(max(DATE),0,4)))<=$(=Date(monthend(yearstart(max(DATE),0,4))))"}>}Agreement_Value__c)
)
Regards,
Aditya

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Could you share your sample file where the issue could be seen?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for your reply but the issue got resolved after changing the number formatting of my measure to "measure expression".
Regards,
Aditya
