Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
saivina2920
Creator
Creator

How to add more condition especially contains in count expression

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

Labels (1)
1 Solution

Accepted Solutions
saivina2920
Creator
Creator
Author

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

[TO]={'*BRITTA*'}

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

View solution in original post

5 Replies
saivina2920
Creator
Creator
Author

Anyone can help us to proceed further....

tresesco
MVP
MVP

@saivina2920 This?

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

saivina2920
Creator
Creator
Author

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
Creator
Creator
Author

if need any more details pls. let me know.

saivina2920
Creator
Creator
Author

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

[TO]={'*BRITTA*'}

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

View solution in original post