Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

stefan_fischer
New Contributor II

Select Date with Status

Hi,

two filter criteria a table should indicate a result. The criteria are Dat. and Status. If a date is selected, all records should be indicated before selected month. If in Listbox DATE "Mar 17" is selected all values before this criteria will be indicated. In additional with STATUS

In addition Listbox STATUS is also filtered.

Listbox Date should be group by MMM_YY.

Regards

Stefan

1 Solution

Accepted Solutions

Re: Select Date with Status

SUM({<Dat = {"<=$(=Date(Max(Dat),'DD.MM.YY'))"}>}Prod)

7 Replies

Re: Select Date with Status

SUM({<Dat = {"<=$(=Date(Max(Dat),'DD.MM.YY'))"}>}Prod)

stefan_fischer
New Contributor II

Re: Select Date with Status

Thanks for your reply. If May 17 is selected, Apr 17 and previous month will be indicated.

How can I group month in listebox DATE?

Re: Select Date with Status

Two possible solutions:

  1. Either create a Calendar table (many examples available in the community) and connect the table to field Dat, or
  2. Add a MonthYear field to your CHARTDATA table using an expression like

    ..., Date(MonthStart(Date#(Dat, 'DD.MM.YY')), 'MMM-YY) AS MonthYear

    and use that new field in your chart.

Best,

Peter

daveamz01
Contributor III

Re: Select Date with Status

Check the attach.

Regards,

David

stefan_fischer
New Contributor II

Re: Select Date with Status

Thanks, it works fine

daveamz01
Contributor III

Re: Select Date with Status

Which solution works fine?

stefan_fischer
New Contributor II

Re: Select Date with Status

Both versions works.

What means 100 in formula?

Dual(Date(Dat, 'MMM YYYY'), Year(Dat)*100+Month(Dat)) AS YMonth

Community Browser