Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Partner
Partner

Showing two years of data in chart without selection

Hi All,

Requirement is like I need to show latest two years of data in Combo chart(i.e. 2018 & 2019), but after selection of year, it should show only selected year's (2018 )data.

Currently I'm using below formula:

if(GetSelectedCount(Year)>0,
count(distinct{<Ppty_Txn_Type2-={'Refinancing'}>}Record_ID),
count(distinct{<Year={">=$(vPrevYear)"},Ppty_Txn_Type2-={'Refinancing'}>}Record_ID)
)

But with this formula, i'm getting all the years on X-Axis as attached.

Please help with this requirement.

2 Replies
Highlighted
Partner
Partner

Re: Showing two years of data in chart without selection

change your expression:

count(distinct{<Year={$(=max(Year)),$(=max(Year)-1)},Ppty_Txn_Type2-={'Refinancing'}>}Record_ID)

Regards

Re: Showing two years of data in chart without selection

Did you try to check 'Suppress Zero-Values' on the presentation tab of the chart properties?