Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
CVTWILLIAMSH4
Contributor
Contributor

Qlikview Set Analysis

I have a straight table and I want to show all the data where the name includes 'inv'

Is there a qlikview equivalent for 'like' in set analysis?

Labels (3)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

See attached qvw to see the effect of the three expressions in the pic below.image.png

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

6 Replies
jaibau1993
Partner
Partner

Hi!

Yes, there is! You can use wildcards in set analysis:

Sum( {<Product = {"inv*"}>} Sales)

Regards,

Jaime.

Vegar
MVP
MVP

Yes you can. Try 

Sum({<name= {"*inv*"}>}Amount)

 

If you want to take any selection of name into consideration as well you could use the following

Sum({<name *= {"*inv*"}>}Amount)
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
anushree1
Specialist II
Specialist II

Hi Vegar,

I am not sure what the below function does

Sum({<name *= {"*inv*"}>}Amount)

 Could you please explain the same

Vegar
MVP
MVP

=Sum({< name *= {"*inv*"} >}Amount)

The expression will calculate the Amount for all [name]  containing 'inv', but it does intersect with any selection you have done in the [name] field.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Vegar
MVP
MVP

See attached qvw to see the effect of the three expressions in the pic below.image.png

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

anushree1
Specialist II
Specialist II

Very well Explained Thank you so much @Vegar