topic Set Analysis in QlikView

Set Analysis

rathnam_qv — Tue, 23 Jul 2013 12:41:44 GMT

Hi all,

i have Quaters data..

in the Month Listbox if i select May, it should give may and April Data as well

how can i achieve that

Urgent Please...

Can any one help me...

Thanks in Advance

Smiley

Tue, 23 Jul 2013 12:51:04 GMT

Add new column to your table

sum({$<Month={$=(Max(Month)-1)}>} Sales)

narender123 — Tue, 23 Jul 2013 12:55:33 GMT

=sum({<Month={">= $(=MaxString(Month)-1)"}>} Amount)

Thanks

Narender

er_mohit — Tue, 23 Jul 2013 13:16:16 GMT

Try this

sum({$<Date = {">=$(=MonthStart(Max(Date),-1))<=$(=MonthEnd(Max(Date)))"},Year=,Month=>}Sale)

mikecrengland — Tue, 23 Jul 2013 15:02:54 GMT

You might try something like:

=sum({<Month *= >} Total <Quarter> SalesAmount)