Please helping me for one set expression .

[prahlad_infy]

Hello Sirs ,

how to be the expression to find count of previliged traders (EMP) which are having zero bidding_id during period selected .

with no change in present only  data model structure .

Thank you .

[sunny_talwar]

What is the expected output based on the data within the sample and selections made?

[prahlad_infy]

Thank you sir for replying

My result should be

PIC FOR REFERENCE

if you see in reference pic i am getting my results by doing filter in excel with two expression ,

i want a single set expression that should give me count in TEXT BOX  ,
all those trader which are privileged but have no complete bidding id in the period selected in calender box ..

[sunny_talwar · Accepted solution]

Try this

=Count({$<Trader_Name = {"=(Count({<Date_of_Bidding={[>=$(=Date(vStart_Date, 'DD-MMM-YYYY'))<=$(=Date(vEnd_Date, 'DD-MMM-YYYY'))]}>} Bidding_ID) + Sum({1} 0)) = 0"}, Marker = {"Previlaged"}>} DISTINCT Trader_Name)

[prahlad_infy]

I think its not working properly . try range - 1/july/2018 to 12/nov/2018

[sunny_talwar]

Yes, because between those two dates, all the Traders seem to have bid for at least 1 bid. Wouldn't that cause you to see 0?

[prahlad_infy]

Sorry sir i think , i made mistake , your solution is correct .. let me double check .

[sergio0592]

Sunny, can you explain why you use [ instead " or ' ?

Date_of_Bidding={[>=$(=Date(vStart_Date, 'DD-MMM-YYYY'))<=$(=Date(vEnd_Date, 'DD-MMM-YYYY'))]}>} Bidding_ID)

Thanks

[sunny_talwar]

Since this whole thing is part of a bigger set analysis... I used [] instead of escape sequence

=Count({$<Trader_Name = {"=(Count({<Date_of_Bidding={[>=$(=Date(vStart_Date, 'DD-MMM-YYYY'))<=$(=Date(vEnd_Date, 'DD-MMM-YYYY'))]}>} Bidding_ID) + Sum({1} 0)) = 0"}, Marker = {"Previlaged"}>} DISTINCT Trader_Name)

[sergio0592]

Ok, understood. Thanks!