Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

filter or avoid values

hi

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

3

4

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..

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

try below expression


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

View solution in original post

5 Replies
Highlighted
Master III
Master III

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.

Highlighted
Creator II
Creator II

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

Highlighted
MVP
MVP

try below expression


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

View solution in original post

Highlighted
Creator II
Creator II

hi kushal,

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

Highlighted
MVP
MVP

You can do like below

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