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.