topic Re: 2015 and beyond data only in QlikView

2015 and beyond data only

knightwriter — Thu, 23 Jul 2015 08:47:22 GMT

Hi All,

I have this expression =count(year([Medal.Won/Lost Date])>='2015') and I want it to show only the data from 2015 and beyond but when I 'clear all', its originates back to all the data from previous years too.

What am I doing wrong? Do I need to set >= 2015 parameter in the dimensions rather than the expression? Thanks in advance.

Re: 2015 and beyond data only

datanibbler — Thu, 23 Jul 2015 08:57:24 GMT

Hi Stephen,

sorry, I don't quite understand your scenario - is this an expression in a chart?

Then it should be independent of selections and when you click "Clear all", that should not affect your chart?`

(that said, to ´promote user_friendliness, I would suggest not putting any limitation in either the chart_dimension nor the chart_expression, but to use an automatic selection (upon opening the sheet) to activate that.

HTH

Re: 2015 and beyond data only

knightwriter — Thu, 23 Jul 2015 09:08:31 GMT

Hi DN,

Thanks for the reply and I am not familiar with the automatic selection function.

My query is an expression in a straight table and when I 'clear all', my data will show from 2003 to 2020 instead of 2015 to 2020.

Re: 2015 and beyond data only

sorrakis01 — Thu, 23 Jul 2015 09:18:26 GMT

Hi,

You can create a Calculated Dimension. If(year='2015','2015')

And expression count(medal won/last date)

But if you like always show the year youn need to use set analysis and use parameter 1.

Count(1{<Year={'2015'}>}medal won/last date)

Regards

Re: 2015 and beyond data only

MayilVahanan — Thu, 23 Jul 2015 09:35:10 GMT

Try like this

Year as Dimension

exp:

If(isnull(Getcurrentselections()), count(Exp) , Count({<Year = {">=2015"}>}Exp))

isnull(Getcurrentselections()) is return null, when there is no selection in any field. suppose your expression need to based on any particular field, then change like this

= if(GetselectedCount(FieldName) = 0, count(Exp) , Count({<Year = {">=2015"}>}Exp))