Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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

View solution in original post

6 Replies
jaibau1993
Partner - Creator III
Partner - Creator III

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

Vegar
MVP
MVP

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

anushree1
Specialist II
Specialist II

Very well Explained Thank you so much @Vegar