topic Select Date with Status in QlikView

Select Date with Status

Anonymous — Mon, 22 May 2017 12:02:28 GMT

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

Re: Select Date with Status

MK_QSL — Mon, 22 May 2017 12:09:08 GMT

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

Re: Select Date with Status

Anonymous — Mon, 22 May 2017 12:17:49 GMT

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

Peter_Cammaert — Mon, 22 May 2017 12:23:28 GMT

Two possible solutions:

Either create a Calendar table (many examples available in the community) and connect the table to field Dat, or
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

Re: Select Date with Status

daveamz — Mon, 22 May 2017 12:25:19 GMT

Check the attach.

Regards,

David

Re: Select Date with Status

Anonymous — Mon, 22 May 2017 12:37:55 GMT

Thanks, it works fine

Re: Select Date with Status

daveamz — Mon, 22 May 2017 12:49:56 GMT

Which solution works fine?

Re: Select Date with Status

Anonymous — Tue, 23 May 2017 06:39:31 GMT

Both versions works.

What means 100 in formula?

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