Qlikview Set Analysis

[CVTWILLIAMSH4]

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?

[jaibau1993]

Hi!

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

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

Regards,

Jaime.

[Vegar]

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]

Hi Vegar,

I am not sure what the below function does

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

 Could you please explain the same

[Vegar]

=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 · Accepted solution]

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

[anushree1]

Very well Explained Thank you so much @Vegar