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: 
Purushothaman
Partner - Creator III
Partner - Creator III

concatenate Two Measures in a Bar Chart

Hi Experts,

I would like to concatenate Two Measures in a Bar Chart like the below example;

Purushothaman_0-1655795053087.png

Below are the two Measures, Anyone, Please help!! 

Measure1: 

NUM(SUM({<BRAND,BrGrp1,BrGrp2,[Year Base],[Year Half Base],[Year Quarter Base],[Year Month Base],Year_Offset={"0"},[Year Month_Offset]={"0"},[Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}VV)
/
SUM(TOTAL<PRICESEG, COUNTRY,[Year Month Base],[Year Quarter Base],[Year Half Base]>{<BRAND,BrGrp1,BrGrp2,[Year Base],[Year Half Base],[Year Quarter Base],[Year Month Base],Year_Offset={"0"},[Year Month_Offset]={"0"},[Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}VV),'#,##0.0%')

Measure2: 

NUM(SUM({<BRAND,PRICESEG,BrGrp1,BrGrp2, [Year Base],[Year Half Base],[Year Quarter Base],[Year Half Base (YYYYHH)] ,[Year Month Base], [Year Quarter Base (YYYYQQ)], Year_Offset={"0"},[Year Month_Offset]={"0"}, [Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}VV/$(Swt_Unit))

/
SUM({<BRAND={'SAMSUNG'},PRICESEG,BrGrp1,BrGrp2, [Year Base],[Year Half Base],[Year Quarter Base],[Year Half Base (YYYYHH)], [Year Month Base], [Year Quarter Base (YYYYQQ)], Year_Offset={"0"},[Year Month_Offset]={"0"}, [Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}RR/$(Swt_Unit)),'#,##0')

 

 

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

use Dual()

 

syntax

=DUAL(  Measure1 & '(' & Measure2 &')' ,  Measure1)

Bar will  be plotted on Measure1 values

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

2 Replies
vinieme12
Champion III
Champion III

use Dual()

 

syntax

=DUAL(  Measure1 & '(' & Measure2 &')' ,  Measure1)

Bar will  be plotted on Measure1 values

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Purushothaman
Partner - Creator III
Partner - Creator III
Author

Thank you  @vinieme12  for your timely support every time. You are a biggest asset for Qlik Community.

@qliksupport