topic Re: filter or avoid values in QlikView

filter or avoid values

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

I have a pivot table as below

Customer Period 012016 022016 032016 042016 052016 062016 072016 082016 092016

1 10 20 10 20 10 20 10 20

2 10 20

10,20 are all the quantities sold..

now i would like to avoid the current month while it is getting refreshed..once in a month the data gets uploaded.. for ex.. if april is the month.. then while reloading 042016 should not be displayed..and the same report is used as a straight table for another analysis..so changes also should not impact the straight tables..

Re: filter or avoid values

Digvijay_Singh — Thu, 09 Jun 2016 07:22:11 GMT

Do you mean you are using fast change icon in the caption to convert into straight table for different purpose?

Also just to confirm you want to avoid display of just current month value rest should be as it is?

If first is true then AFAIK its not possible to make changes in same chart when another chart type is selected, not sure though as of now, will give it a try.

Re: filter or avoid values

raadwiptec — Thu, 09 Jun 2016 07:29:58 GMT

hi dig vijay it is not the same chart..iam using the the data from script to make another straight table...

Re: filter or avoid values

Kushal_Chawda — Thu, 09 Jun 2016 07:31:14 GMT

try below expression

= Sum({<Period -={"$(=date(today(),'MMYYYY'))"}>} Quantity)

Re: filter or avoid values

raadwiptec — Thu, 09 Jun 2016 07:48:01 GMT

hi kushal,

how to give multiple conditions in the same expression..as already expression the existing sum

Re: filter or avoid values

Kushal_Chawda — Thu, 09 Jun 2016 08:16:40 GMT

You can do like below

sum({<Period -={"$(=date(today(),'MMYYYY'))"}, Field1={'a'},Field2={'3'}>} Quantity)