topic Re: Set Analysis using more than one condition in QlikView

Set Analysis using more than one condition

Sat, 06 Dec 2014 07:22:36 GMT

I have the following fields

1. Date

2. Entry type

3. Customer type

4. Amount

i want the sum of Amount where entry type =0, Customer Type = Third party and amount should be YTD.

i also want the above forMTD.

if select June, it should be jan to Jun and for the month of June with the above conditions.

PrashantSangle — Sat, 06 Dec 2014 07:30:29 GMT

Hi,

Try like

YTD=

Sum({<Customer_Type={"Third party"},Entry_type={"0"},Date={">$(=date(Yearstart(max(date))))<=(date(max(date)))"}>}Amount)

Regards

Sat, 06 Dec 2014 07:38:15 GMT

it is not working.

alkesh_sharma — Sat, 06 Dec 2014 08:55:06 GMT

Make two variables, for Max of date and Year start and use the following expression:

Variable YearStart = YearStart(Date#(Max(Date));

Variable MaxDate = Date#(Max(Date))

Hi,

Try like

YTD=Sum({<Customer_Type={"Third party"},Entry_type={"0"},Date={">$(YeartStart)<=(MaxDate)"}>}Amount)

Sat, 06 Dec 2014 11:19:10 GMT

Thanks a lot.

but i want both YTD and MTD.

When i select a month, it is showing only for that month.

how do i get data for both YTD and MTD.

please help.