topic Re: Set analysis (Month) in QlikView

Set analysis (Month)

Anonymous — Mon, 09 Feb 2015 08:58:53 GMT

Hi,

It is possible with set analysis to select from January to the current month selected? For example, if I select 'April' in field Month, my chart will display from January to April.

I tried different things but I couldn't do it. Can anybody help me?

Thanks in advanced.

Daniel

Re: Set analysis (Month)

giakoum — Mon, 09 Feb 2015 09:00:04 GMT

see attached

Re: Set analysis (Month)

tresB — Mon, 09 Feb 2015 09:01:15 GMT

Try like:

sum([$<DateField= {">=$(=YearStart(max(DateField))) <= $(=max(DateField))"}>} Amount)

Re: Set analysis (Month)

Anonymous — Mon, 09 Feb 2015 09:11:34 GMT

Sorry I thinkt that I don't explained very well.

I want that in my chart if I selected April in field Month, chartt will display from January to April. So, dimension in my chartt is field Month. It is possible to do this with 'Calculated Dimension'?

Re: Set analysis (Month)

Anonymous — Mon, 09 Feb 2015 09:34:28 GMT

This works for me.

Thanks to everyone for your help.