Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
UserID2626
Contributor 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
Highlighted
MVP & Luminary
MVP & Luminary

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

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
Highlighted
MVP & Luminary
MVP & Luminary

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

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