topic Re: View data less then or equal te selected date in Straight table in QlikView

View data less then or equal te selected date in Straight table

kris_vliegen — Wed, 21 Jan 2015 10:40:02 GMT

Hi All,

I have a straight table and a listbox with year and 1 with month selection.

I would like to see data in my straight table from the month I selected and all the previous months.

Is this possible. Because now if I select an Year and Month I only see the data from that month.

Regards,

Kris

Re: View data less then or equal te selected date in Straight table

Gysbert_Wassenaar — Wed, 21 Jan 2015 10:45:17 GMT

It should be easy if you also have a date field. You can use set analysis to show the data from the selected month and previous months: sum({<MyDateField={'<=$(=max(MyDateField))'}>} Amount)

Re: View data less then or equal te selected date in Straight table

jpenuliar — Wed, 21 Jan 2015 10:53:33 GMT

a Date range selection(with min max dates) may help you regarding your problem.

Date Selections - By Period & Range

Re: View data less then or equal te selected date in Straight table

kris_vliegen — Wed, 21 Jan 2015 10:57:39 GMT

Thank you Gysebert for your reaction.

But as you can see in the screenshot I only see values of the selected month in my straight table.

The variable (vMaxDatum) is calculated as

=num(makedate(if( GetSelectedCount( _CalYear) > 0, _CalYear, max(_CalYear)) , if( GetSelectedCount( _CalMonth) > 0, num(_CalMonth), max(_CalMonth)) , if( GetSelectedCount( _CalDay) > 0, _CalDay, max(_CalDay))))

Re: View data less then or equal te selected date in Straight table

Gysbert_Wassenaar — Wed, 21 Jan 2015 11:01:26 GMT

Ah, my mistake. You also need to 'reset' the selection in the other fields:

sum({<Year=,Month=,MyDateField={'<=$(=max(MyDateField))'}>} Amount)

You don't need your variable vMaxDatum. Simply use $(=max(MyDateField))

Re: View data less then or equal te selected date in Straight table

kris_vliegen — Wed, 21 Jan 2015 11:06:47 GMT

Thank you!

Now I see it, it is indeed logical.