Set Expression

[qlikview979]

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

[qlikview979]

Hi experts,

help me on this

avinashelite‌loveisfail‌jagan‌stalwar1‌

regards

[tresesco]

Try like:

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

[qlikview979]

Hi Brother,

its showing Zero

[Anil_Babu_Samineni]

May be this?

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

[qlikview979]

Hi Anil,

Not working

[Anil_Babu_Samineni]

Or

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

[Kushal_Chawda]

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_)

[qlikview979]

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.

[tresesco]

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)?