topic Re: Excluding selected range in QlikView

Excluding selected range

Sun, 05 Oct 2014 14:09:32 GMT

Hi to Everyone.

I have a chart with these fields:

Dimenssions:

-date

-invoice number

Expression:

QUANT (the expression is : sum({$<YEAR-={$(YEAR)}>} PPC_IVQUANT)

I have two field for selection YEARS and MONTHS.

What I want to do, is to exclude from this tabe lines where the date falls on the selected dates range ( The test here is for the year only, but it didnt work out).

I couldnt it solve it after many times. Please consider that the user can selected some months together.

I can't use "1-$ " becuse I want the results to regard the selected product in a nother field/

I will appriciate any help/

Thnak you,

Osher Sassoni.

Re: Excluding selected range

ashfaq_haseeb — Sun, 05 Oct 2014 14:12:14 GMT

Hi,

Try something like this

sum({$<YEAR=E(YEAR)>} PPC_IVQUANT)

Regards

ASHFAQ

Re: Excluding selected range

Sun, 05 Oct 2014 14:41:56 GMT

Thank you for your reply.

I still have problem with the dimenssion - DATE . How do I exclude from it dates which fall in the selected range ??

Now it still shows all dates without any restriction.

Re: Excluding selected range

ashfaq_haseeb — Sun, 05 Oct 2014 14:55:14 GMT

Hi,

You can add DATE dimension too.

sum({$<YEAR=E(YEAR),DATE=E(DATE)>} PPC_IVQUANT)

hope it helps

Regards

ASHFAQ

Re: Excluding selected range

Sun, 05 Oct 2014 15:25:54 GMT

Thank you but it still doesn't work.

I have a chart table with these fields: Date(dimenssion), Invoice_num(dimenssion),line(dimenssion) , Quant(expression).

The table shows invoice's lines.

What I want to do is to show in the table only lines which don't fall in the selected range of dates.

mean to say that if I have for example :

01/01/12 1234 1 40

01/01/11 5678 1 50

05/04/11 8098 3 40

and I have selected Year = 2011 and Months = feb and Apr , I will see in table only lines 1 and 2.

I used your expression for the Quant field, but I still get all lines. I think i should use kind of calculated dimenssion, for my date field but can't figure which expression I should use. I tried yours but it stil dont work.

Re: Re: Excluding selected range

ashfaq_haseeb — Sun, 05 Oct 2014 16:00:25 GMT

Like this

Regards

ASHFAQ