topic Re: Set Expression in QlikView

Set Expression

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

Hi Experts,

How can i write set expression for below code

=count(DISTINCT if(len(GatePassDate)= 0,if(len([Repair Category])<> 0, BBND_ROs)))

regards

mahesh

Re: Set Expression

qlikview979 — Wed, 28 Jun 2017 09:21:29 GMT

Hi experts,

help me on this

avinashelite‌loveisfail‌jagan‌stalwar1‌

regards

Re: Set Expression

tresB — Wed, 28 Jun 2017 09:22:08 GMT

Try like:

=count(DISTINCT {<GatePassDate={"=len(GatePassDate)= 0"}, [Repair Category]={"=len([Repair Category])<> 0"} >} BBND_ROs)

Re: Set Expression

qlikview979 — Wed, 28 Jun 2017 09:24:15 GMT

Hi Brother,

its showing Zero

Re: Set Expression

Anil_Babu_Samineni — Wed, 28 Jun 2017 09:32:27 GMT

May be this?

Count({<GatePassDate = {"=Len(GatePassDate) = 0"}, [Repair Category] -= {' ', '0','-'}>} DISTINCT BBND_ROs)

Re: Set Expression

qlikview979 — Wed, 28 Jun 2017 09:33:49 GMT

Hi Anil,

Not working

Re: Set Expression

Anil_Babu_Samineni — Wed, 28 Jun 2017 09:33:59 GMT

Count({<GatePassDate = {"=Len(GatePassDate) = 0"}>} DISTINCT if(len([Repair Category])<> 0, BBND_ROs))

I don't think whether your condition gets any performance issue, You can use that

Re: Set Expression

Kushal_Chawda — Wed, 28 Jun 2017 09:36:20 GMT

Move this expression to script

if(len(GatePassDate)= 0,if(len([Repair Category])<> 0, BBND_ROs)) as BBND_ROs_

Now write expression

Count(distinct BBND_ROs_)

Re: Set Expression

qlikview979 — Wed, 28 Jun 2017 09:36:56 GMT

Not working

I am checking this text object,its showing result zero.

Above my if condition showing exact count, but i want in same expression in set level.

Re: Set Expression

tresB — Wed, 28 Jun 2017 09:37:06 GMT

Where are you using this formula, in a chart or text box? What is the output you are getting with your expression (without set analysis)?

Re: Set Expression

qlikview979 — Wed, 28 Jun 2017 09:38:50 GMT

Hi Bro,

I am getting correct count with my if condition, but i am trying to write in set expression

is it possible.

Regards

Re: Set Expression

Kushal_Chawda — Wed, 28 Jun 2017 09:40:48 GMT

=Count({<BBND_ROs={"=len(GatePassDate)= 0 and len([Repair Category])<> 0"}>} distinct BBND_ROs)

Re: Set Expression

Kushal_Chawda — Wed, 28 Jun 2017 09:42:00 GMT

As performance point of view, we should avoid the if conditions in expression, hence I suggested to move it in script instead

Re: Set Expression

qlikview979 — Wed, 28 Jun 2017 09:42:43 GMT

Bro,

Its showing wrong count

Re: Set Expression

Anil_Babu_Samineni — Wed, 28 Jun 2017 09:44:14 GMT

Can you try this may be in script, And FYI - I don't think whether you will get any performance issue using simple condition from your original post

Load GatePassDate,

[Repair Category],

BBND_ROs,

if(len(GatePassDate)= 0,if(len([Repair Category])<> 0, 1,0) as Flag

Resident Table

And set analysis may be

Count({<Flag = {1}>}Distinct BBND_ROs)

Re: Set Expression

Kushal_Chawda — Wed, 28 Jun 2017 09:44:49 GMT

Create one field in script

LOAD *,

rowno() as Row

FROM table;

Now use this expression

=Count({<Row={"=len(GatePassDate)= 0 and len([Repair Category])<> 0"}>} distinct BBND_ROs)

Re: Set Expression

qlikview979 — Wed, 28 Jun 2017 09:45:46 GMT

Ok Bro

Thanks

Re: Set Expression

Anil_Babu_Samineni — Wed, 28 Jun 2017 09:46:18 GMT

Bhai, If we use Direct condition If(Condition1, If(Condition2..), Count(..)) this may gets performance. I wonder, How performance issue is involved when we write Count(...If(...If(...))).

Just want to know, Reply me if you feel to share

Re: Set Expression

qlikview979 — Wed, 28 Jun 2017 09:55:05 GMT

Hi Bro,

i am using in Text object and getting count 880 as per based on input.

Regards

Re: Set Expression

tresB — Wed, 28 Jun 2017 09:56:50 GMT

Could you post your sample qvw?