Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
MK_QSL
MVP
MVP

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

View solution in original post

7 Replies
MK_QSL
MVP
MVP

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

Anonymous
Not applicable
Author

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?

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

daveamz
Partner - Creator III
Partner - Creator III

Check the attach.

Regards,

David

Anonymous
Not applicable
Author

Thanks, it works fine

daveamz
Partner - Creator III
Partner - Creator III

Which solution works fine?

Anonymous
Not applicable
Author

Both versions works.

What means 100 in formula?

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