Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
stefan_fischer
Contributor II
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
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)

View solution in original post

stefan_fischer
Contributor II
Contributor II
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

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
Creator III
Creator III

Check the attach.

Regards,

David

stefan_fischer
Contributor II
Contributor II
Author

Thanks, it works fine

daveamz01
Creator III
Creator III

Which solution works fine?

stefan_fischer
Contributor II
Contributor II
Author

Both versions works.

What means 100 in formula?

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