topic Re: set expression issue in QlikView

set expression issue

Anonymous — Tue, 14 Jul 2015 10:45:09 GMT

Hi,

I need a set expression in this formula:

count({AS <Field1=, Field2=, ..., FieldN=>} distinct Media)

As you see in my set expression I list all available fields in my application except the field Media.

Is it possible to simplify the formula? Maybe, there is way not to list all the field available.

Thank you in advance,

Larisa

Re: set expression issue

lironbaram — Tue, 14 Jul 2015 10:48:11 GMT

count({1<Media=p(Media)>}Distinct Media)

Re: set expression issue

avinashelite — Tue, 14 Jul 2015 10:51:50 GMT

try like :

Count({1}distinct Media)

this will give the count independent of all the other fields

Re: set expression issue

jagan — Tue, 14 Jul 2015 10:53:22 GMT

Hi,

Check this link

Ignore all selections except some specific fields using Set Analysis

OR else try

count({1<Media=P(Media)>} distinct Media)

Regards,

Jagan.

Re: set expression issue

maxgro — Tue, 14 Jul 2015 10:56:30 GMT

I think here

Ignore all selections except some specific fields using Set Analysis

Re: set expression issue

Anonymous — Tue, 14 Jul 2015 12:53:23 GMT

Thanks everyone for your comments!

Almost each of you advised the expression {1<Media=P(Media)>} or {AS*1<Media=P(Media)>} as I'm using an alternate state.

I don't know why but it gives a different result than my initial formula: count({AS <Field1=, Field2=, ..., FieldN=>} distinct Media). Maybe, it is due to the peculiariteis of my application.

I'll use 'count({AS <Field1=, Field2=, ..., FieldN=>} distinct Media)' in my app then because I don't see a simpler alternative.

Thanks for sharing the link with some extra explanation!