multiple dimensions on x axis bar chart

[krishnakv831]

Experts,

I'm new to Qliksense. I need to develop bar char with the previous year total and YTD information on X-axis. Y-axis contains total.

I don't know how to show to one bar for previous year and another for YTD.

Could you please provided inputs on this.very urgent.

I'm also looking for new Qliksense template so that I can present to my demo meeting. Please share some nice templates to work on.

Regards,

Krishna

[salonicdk28]

Please try to create flag say one for YTD and another for previous year like below and then add that flag as dimensions and write expression based on that

LOAD
Segment,
Country,
Product,
Profit,
MONTH_KEY,
'Prievious_Year_YTD' as Period,

FROM [lib://Download/Financial Sample.xlsx]
(ooxml, embedded labels, table is Sheet1);

LOAD
Segment,
Country,
Product,
Profit,
MONTH_KEY,
'Current_Year_YTD' as Period,

FROM [lib://Download/Financial Sample.xlsx]
(ooxml, embedded labels, table is Sheet1);

expression in chart-

IF(Period='Current_Year_YTD',

Sum({<MONTH_KEY={">=$(=Date(YearStart(today()),'YYYYMM'))<=$(vCurrYearend)"},Month=>}measure)

IF(Period='Prievious_Year_YTD',

Sum({<MONTH_KEY={">=$(=Date(AddYears(YearStart(Today()),-1),'YYYYMM'))<=$(vPriorYearend)"},Month=>}measure)))

where vCurrYearend=max({<Year={$(=Year(Today()))}>}MONTH_KEY) and 

vPriorYearend=max({<Year={$(=Year(Today())-1)}>}MONTH_KEY)