topic Re: Doubt about one dimension in QlikView

Doubt about one dimension

Mon, 26 Jan 2015 18:08:51 GMT

Hi.

I have the field

YEAR - MONTH as dimension in one graphic. but i have year from 2005 to 2015 and i'd like to use only from 2013 to 2015.

I tried a if(not(isnull but when i use that a lot of values dissapear.

Any ideas?

Thank you

Greetings!

Mon, 26 Jan 2015 18:15:26 GMT

Hi Jeremias,

do you just want the last two years to show in a listbox? or is this a chart?

In a chart I would recommend using set analysis in your expressions so the chart only evaluates for the years you want.

If you want this as a limit in your listbox, then create the listbox as an expression and set the criteria in there

i.e listbox as expression if([YEAR - MONTH]>='201301', [YEAR - MONTH])

hope that helps

Joe

Clever_Anjos — Mon, 26 Jan 2015 18:15:40 GMT

try

Sum({<DIM={'2013*','2014*','2015*'}>}Value) as your expression

Mon, 26 Jan 2015 18:24:14 GMT

Hi.

is a pivot table

i dont wanna have all those years with null values.

My expression is this alt(Count( alt(Money,0)),0)

I tried this but didn't work

=alt(Count({<Month_year={'2013*','2014*','2015*'}>} alt(CobranzasMonto,0)),0)

Mon, 26 Jan 2015 18:29:02 GMT

i tried this but didn't work

=alt(Count({<Month_year={'2013*','2014*','2015*'}>} alt(CobranzasMonto,0)),0)