Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
perumal_41
Partner - Specialist II
Partner - Specialist II

Hi

Use this expression usefule for u.

=Count(

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

Distinct ItemCode)

Not applicable
Author

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
Author

Dear Community.

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

Thanks,

Mukram.

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

Dear Gysbert,

It's working perfectly.

Thank you so much.

I highly appreciated your effort.

Thanks,

mukram.

Not applicable
Author

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.