topic Filter in QlikView

Filter

Tue, 16 Dec 2014 09:28:45 GMT

Hello,

I want to filter for the following, can one of you let me know if there is a way to do this.

If((Flag = 1 and Year = 2013) and (Flag = 0 and Year =2014), Sum(sales))

I'm not sure how to do this in Qlikview.

Thanks

Re: Filter

sushil353 — Tue, 16 Dec 2014 09:30:50 GMT

Hi,

Try this:

sum({<Flag={'1'}>*<Flag={'2013'}>*<Flag={'0'}>*<Year={'2014'}>}sales)

HTH

Sushil

Re: Filter

sujeetsingh — Tue, 16 Dec 2014 09:31:34 GMT

Where you want to filter?

If it is at UI level you can derieve a flag in Script and provide the Flag as Filter.

Re: Filter

Anonymous — Tue, 16 Dec 2014 09:44:18 GMT

You can try this:

=sum(if(Flag=1 and Year=2013,Sales,if(Flag=0 and Year=2014,Sales)))

Re: Filter

ThornOfCrowns — Tue, 16 Dec 2014 09:56:56 GMT

(Flag = 1 and Year = 2013) and (Flag = 0 and Year =2014) is a contradiction, Flag cannot be 1 and 0, Year cannot be 2013 and 2014.

Re: Filter

Tue, 16 Dec 2014 10:15:55 GMT

I believe, you should do it sum them separately:

If((Flag = 1 and Year = 2013) and (Flag = 0 and Year =2014), Sum(sales))

sum({<Flag={1},Year={2013}>}sales) + sum({<Flag={0},Year={2014}>}sales)

sum({<Flag={1},Year={2013}>+<Flag={0},Year={2014}>}>}sales)

Hope this was helpful

Thanks,

Singh

Re: Filter

Tue, 16 Dec 2014 13:01:12 GMT

Wouldn’t this be equal to

Where Flag = 1 and Year = 2013 and Flag = 0 and Year = 2014? I’m expecting Where (Flag = 1 and Year = 2013) and (Flag = 0 And Flag = 2014)

Re: Filter

Tue, 16 Dec 2014 13:01:12 GMT

Filter an expression.

Re: Filter

Tue, 16 Dec 2014 13:01:12 GMT

James

Below is the example

Client Year Flag

12345 2013 1

12345 2014 0

12346 2013 1

12346 2014 1

I want to identify only Client 12345. Is there any way to identify that client in Qlikview?

Thanks

Venkatachalam.N

Re: Filter

Anonymous — Tue, 16 Dec 2014 13:06:18 GMT

Use this:
Only({<Flag={1},Year={2013}>}Client) + Only({<Flag={0},Year={2014}>}Client)

Re: Filter

Tue, 16 Dec 2014 13:07:29 GMT

Based on this example, the below should work for you.

Only({<Flag={'1'},Year={'2013'}>+<Flag={'0'},Year={'2014'}>}Client)

hope that helps

Joe