Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excluding selected range

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.

5 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

Try something like this

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


Regards

ASHFAQ

Not applicable
Author

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.

ashfaq_haseeb
Champion III
Champion III

Hi,

You can add DATE dimension too.

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

hope it helps

Regards

ASHFAQ

Not applicable
Author

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.

ashfaq_haseeb
Champion III
Champion III

Like this

Regards

ASHFAQ