Bar Chart 6 monthsTrend

[phaneendradodda]

I am new to Qlik sense ..

My issue is .. I have a guage chart object that displays the value for the selected MTD (list box object).

 I wanted to display a bar chart that presents the values for the last 6 months from the selected MTD. For eg: If I select July 2009, guage chart displays value for July and the bar chart should display the values for the months - Jan, Feb, Mar....Jun.

Date(MonthStart(TempDate),'MMMYYYY') as Business_MonthYear ......... in Master calendar

My Gauge chart value in % and the Expression is...

Count( { < [Business Area] = , Scorecard_Date= { “ >= $(vSelectedMonthStart  )< = $ (vSelectedDate) ” },

CTRCT_CDE_BR_Date_Src_Create = { “ < =$ (vSelectedDate) “ } ,

CTRCT_CDE_BR_Date_EFF_END = { “ >= $(vSelectedMonthStart  ) “ } ,

IDQ_Collibra_Date_Rule_End = { “ >= $(vSelectedMonthStart  ) “ } ,

IDQ_Collibra_Date_Rule_Create = { “ < =$ (vSelectedDate) “ }>} Distinct IDQ_Collibra_CDE_ID)

/

Count( { < [Business Area] = , CTRCT_CDE_BR_Date_Src_Create = { “ < =$ (vSelectedDate) “ } ,

CTRCT_CDE_BR_Date_EFF_END = { “ >= $(vSelectedMonthStart  ) “ } ,

Contracts_Business_Date = { “ >= $(vSelectedMonthStart  )< = $ (vSelectedDate) ” },

CDE_Status _Check = {“Accepted”, “Candidate”}>} Distinct CDE_ID)

 in expression some variable is there related to MTD.

Thanks and Regards.