topic Re: Need a help in QlikView

Need a help

Mon, 03 Dec 2012 06:47:42 GMT

Dear Community.

I need a help in counting the ItemCode with two conditions on two different fileds.

kindly find the attachment.

so please someone can help me out.

Thanks,

Mukram.

Re: Need a help

perumal_41 — Mon, 03 Dec 2012 06:59:22 GMT

Use this expression usefule for u.

=Count(

{<ItemCode={"=ProcedurecatID=5 or ProcedureID=18"}>}

Distinct ItemCode)

Re: Need a help

Mon, 03 Dec 2012 07:14:16 GMT

Dear Perumal A.

Thanks for your Reply.

it's not working .

i added some more records in the Inline table .

find the attachement.

Re: Need a help

Mon, 03 Dec 2012 07:46:32 GMT

Dear Community.

Please somebody help me to solve the above issue it's urgent.

Thanks,

Mukram.

Re: Need a help

Gysbert_Wassenaar — Mon, 03 Dec 2012 08:35:14 GMT

Try: =count({<ItemCode={"=count({< ProcedurecatID={5}>} ItemCode)>0"} >*<ItemCode={"=count({< ProcedureID={18}>} ItemCode)>0"} > } distinct ItemCode)

Re: Need a help

Mon, 03 Dec 2012 09:40:45 GMT

Dear Gysbert,

It's working perfectly.

Thank you so much.

I highly appreciated your effort.

Thanks,

mukram.

Re: Need a help

Thu, 06 Dec 2012 17:03:43 GMT

Hi,

How can I write the difference of these two expressions as one expression without changing the result.

Count({<ItemTransactions.ProcedureID={5},ItemTransactions.DBFlag={5}>}ItemCode

)

(count(
{<ItemCode={"=count({<ItemTransactions.ProcedureID={5}>} ItemCode)>0"} >

*
<ItemCode={"=count({< ItemTransactions.ProcedureID-={3,7,49}>} ItemCode)>0"},ItemTransactions.DBFlag={5} > } distinct ItemCode))

If possible, how can I use the result of this as a Select in field trigger on ItemCode field.

Any help would be greatly appreciated.

Thanks,

-Khaled.