topic Re: Seeing data only greater than 2014 in QlikView

Seeing data only greater than 2014

Anonymous — Thu, 02 Jun 2016 20:33:07 GMT

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!

Re: Seeing data only greater than 2014

Anonymous — Thu, 02 Jun 2016 21:36:15 GMT

Any help on this please

Re: Seeing data only greater than 2014

rwunderlich — Thu, 02 Jun 2016 21:48:25 GMT

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Seeing data only greater than 2014

Anonymous — Thu, 02 Jun 2016 21:58:26 GMT

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

Re: Seeing data only greater than 2014

rwunderlich — Fri, 03 Jun 2016 00:14:11 GMT

Remove your Background color expressions from the Dimensions and Expressions.

-Rob

Re: Seeing data only greater than 2014

Fri, 03 Jun 2016 03:15:51 GMT

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?

Re: Seeing data only greater than 2014

bindu_apte — Fri, 03 Jun 2016 05:43:00 GMT

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.

Re: Seeing data only greater than 2014

qlikview979 — Fri, 03 Jun 2016 05:47:19 GMT

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.