topic Re: Please helping me for one set expression . in QlikView

Please helping me for one set expression .

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

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 .

Re: Please helping me for one set expression .

sunny_talwar — Fri, 02 Nov 2018 17:13:24 GMT

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

Re: Please helping me for one set expression .

prahlad_infy — Fri, 02 Nov 2018 17:37:51 GMT

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

Re: Please helping me for one set expression .

sunny_talwar — Fri, 02 Nov 2018 17:48:30 GMT

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)

Re: Please helping me for one set expression .

prahlad_infy — Fri, 02 Nov 2018 18:09:17 GMT

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

Re: Please helping me for one set expression .

sunny_talwar — Fri, 02 Nov 2018 18:11:45 GMT

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?

Re: Please helping me for one set expression .

prahlad_infy — Fri, 02 Nov 2018 18:14:16 GMT

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

Re: Please helping me for one set expression .

sergio0592 — Fri, 02 Nov 2018 21:00:57 GMT

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

Re: Please helping me for one set expression .

sunny_talwar — Fri, 02 Nov 2018 21:33:28 GMT

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

Re: Please helping me for one set expression .

sergio0592 — Fri, 02 Nov 2018 21:49:52 GMT

Ok, understood. Thanks!