Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Creator II
Creator II

Multiple Value Check in dimension & Certain text in long string @ Set identifier qlik Sense

Hi Everyone,

I need to check a particular word (multiple words) in a long string.

Eg. My strings are

Total sale for product Asft is 34

Total sale for product A9ft is 0

Total sale for product Asorft is 3

Total sale for product QASXCD is 4

Total sale for product PMJNHY is 74

Total sale for product yhjuik is 344

Total sale for product awdsft is 3674 ...

I have to take count of Asft sale - Count({<Product={"*Asft*"}>}ID) //Working fine

Now i need to exclude 2 products(Asft,A9ft) and need to find count of other 5

Count({<Product - ={"*Asft*"}>}ID) //this will exclude only Asft

How to give multiple values in set analysis instead of writing multiple times same condition like below

Count({<Product - ={"*Asft*"}, Product  -={"*A9ft*"}>}ID)

 

1 Solution

Accepted Solutions
kaushiknsolanki

Hi,

Try this.

Count({<Product - ={"*Asft*","*A9ft*"}>}ID)

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

1 Reply
kaushiknsolanki

Hi,

Try this.

Count({<Product - ={"*Asft*","*A9ft*"}>}ID)

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post