topic Re: How to add more condition especially contains in count expression in QlikView

How to add more condition especially contains in count expression

saivina2920 — Fri, 15 Nov 2024 23:29:31 GMT

I have to apply contains along with more condition in the below expressions.

=Count({<[TO]={'BRITTA-DEALER'},[FROM]={"$(vManufacturer)"}>} DISTINCT [ORDER_ID_NUMBER])

1. i want to get [TO] contains {'BRITTA'} only instaed of [TO]={'BRITTA-DEALER'}

2. i want to add one more condition like [Status]='NEW' along with the above expression.

How to modify the above expressions along with above two points.

pls.help..

saivina2920 — Tue, 08 Dec 2020 09:40:59 GMT

Anyone can help us to proceed further....

tresB — Tue, 08 Dec 2020 10:07:01 GMT

=Count({<[TO]={'BRITTA'},[Status]={'NEW'},[FROM]={"$(vManufacturer)"}>} DISTINCT [ORDER_ID_NUMBER])

saivina2920 — Tue, 08 Dec 2020 11:20:21 GMT

Thanks for your reply.

[TO] should not be hard coded like ['BRITTA']

Because column "TO" fetch all the record which contains "BRITTA"

{'BRITTA-DEALER'}

{'BRITTA-SHOPPER'}

{'BRITTA-AGENCY'}

{'BRITTA-REGION'}

etc....

saivina2920 — Tue, 08 Dec 2020 12:56:01 GMT

if need any more details pls. let me know.

saivina2920 — Tue, 08 Dec 2020 16:11:40 GMT

For contains, i used below and it's working.

[TO]={'*BRITTA*'}

=Count({<[TO]={'*BRITTA*'},[Status]={'NEW'},[FROM]={"$(vManufacturer)"}>} DISTINCT [ORDER_ID_NUMBER])