Seeing data only greater than 2014

[Anonymous]

Hi

I have a chart in which I wanted to see data only where year is greater than 2014 , but as soon as I add the filter in set analysis expression the color coding of Priority when an Year is selected changes .. how do I enable my chart not to change color and also enable to show only 2014

Thanks!

[Anonymous]

Any help on this please

[rwunderlich]

Check "Persistent Colors" on the Colors tab of the chart.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[Anonymous]

it still changes the color of the bars as soon as click year 2016 , and also 2016 is not selected in the chart.

[rwunderlich]

Remove your Background color expressions from the Dimensions and Expressions.

-Rob

[#6]

I'm very new to Qlik sense 2.x however your test file that you attached, I'm only able to see year 2015 and 2016 in date field. are you missing data for 2014?

[bindu_apte]

Hi,

Please try this using below expression chart.

Count({<IsEscape={1},Status={'Open'},Year = {"=Year follows 2014"}>}[Jira Key])

Let me know if issue still persists.

[qlikview979]

Hi Ramya,

Your Original expression is :-

Count({<IsEscape={1},Status={'Open'},Year = {">=2014"}>}[Jira Key])

Change your Expression write like this:-

Count({<IsEscape={1},Status={'Open'},Year = {">2014"}>}[Jira Key])

Regards,

Mahesh.