topic Re: Qlikview Set Analysis in QlikView

Qlikview Set Analysis

CVTWILLIAMSH4 — Sat, 16 Nov 2024 03:03:04 GMT

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?

Re: Qlikview Set Analysis

jaibau1993 — Wed, 10 Jul 2019 08:59:19 GMT

Hi!

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

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

Regards,

Jaime.

Re: Qlikview Set Analysis

Vegar — Wed, 10 Jul 2019 09:11:42 GMT

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)

Re: Qlikview Set Analysis

anushree1 — Wed, 10 Jul 2019 09:16:21 GMT

Hi Vegar,

I am not sure what the below function does

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

Could you please explain the same

Re: Qlikview Set Analysis

Vegar — Wed, 10 Jul 2019 09:47:57 GMT

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

Re: Qlikview Set Analysis

Vegar — Wed, 10 Jul 2019 09:52:16 GMT

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

Re: Qlikview Set Analysis

anushree1 — Wed, 10 Jul 2019 10:05:29 GMT

Very well Explained Thank you so much @Vegar