Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Need a help

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.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Need a help

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


talk is cheap, supply exceeds demand
6 Replies
Partner
Partner

Re: Need a help

Hi

Use this expression usefule for u.

=Count(

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

Distinct ItemCode)

Not applicable

Re: Need a help

Dear Perumal A.

Thanks for your Reply.

it's not working .

i added some more records in the Inline table .

find the attachement.

Not applicable

Re: Need a help

Dear Community.

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

Thanks,

Mukram.

MVP & Luminary
MVP & Luminary

Re: Need a help

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


talk is cheap, supply exceeds demand
Not applicable

Re: Need a help

Dear Gysbert,

It's working perfectly.

Thank you so much.

I highly appreciated your effort.

Thanks,

mukram.

Not applicable

Re: Need a help

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.