topic Re: Set Expression Question in QlikView

Set Expression Question

Fri, 08 Jul 2016 19:55:04 GMT

Hi all,

I have a question about Set Expression in QlikView.

What is the difference between {1<dimension1=a>} from {1*<dimension1=a>}.

I guess the first one is the set of dimension1=a without any selection while the second one means the set with current selection. Is that correct?

Best,

Re: Set Expression Question

sunny_talwar — Fri, 08 Jul 2016 20:09:02 GMT

As I read and understand, may be this

1) {1<dimension1={a}>} means that don't filter on anything {1}, but only display where dimension1 = a

2) {1*<dimension1={a}>} is equivalent to {1*$<dimension1={a}>}. which is also equivalent to {$<dimension1={a}>} means that filter on all fields except dimension1 where dimension1 always need to show a.

Re: Set Expression Question

vinieme12 — Fri, 08 Jul 2016 20:16:07 GMT

A few post that you may find useful

http://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/

Set Analysis: syntaxes, examples