Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

daniel_garcia_m
New Contributor II

Set analysis (Month)

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Set analysis (Month)

Try like:

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

4 Replies
giakoum
Honored Contributor II

Re: Set analysis (Month)

see attached

MVP
MVP

Re: Set analysis (Month)

Try like:

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

daniel_garcia_m
New Contributor II

Re: Set analysis (Month)

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'?

daniel_garcia_m
New Contributor II

Re: Set analysis (Month)

This works for me.

Thanks to everyone for your help.

Community Browser