Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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