topic Re: Ignore selection in Set in QlikView

Ignore selection in Set

MK9885 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'd like to ignore the selection of few filters in my dashboard.

num(only({$<Field1, Field2,FIELD1toIGNORE=,FIELD2toIGNORE=>} Dimension),'#.00%')

I used $ and = in set but when I select a field my chart disappears.

The chart is using static values from xl file and linked to fact using composite key.

Can anyone suggest how to ignore filter selection and give them static value?

neelamsaroha1575‌

stalwar1‌

loveisfail‌

Thanks.

Re: Ignore selection in Set

vishsaggi — Thu, 29 Jun 2017 18:59:26 GMT

With your current expression is it not ignoring? Can you share an example if possible?

Re: Ignore selection in Set

MK9885 — Thu, 29 Jun 2017 19:02:53 GMT

No it's not.

I can't think of how to create a sample for this current scenario.

Cus the data I have is in millions and then there is a static file

The static file doesn't have link to the fields/Dim which I'm trying to ignore... It is just connected to Fact based on composite key.

But filters in front end has no connection to the static file.

Re: Ignore selection in Set

vishsaggi — Thu, 29 Jun 2017 19:14:24 GMT

Can you Mockup some data in excel and send it through. ?

Re: Ignore selection in Set

MK9885 — Thu, 29 Jun 2017 19:35:49 GMT

ok, I'll.

thanks

Re: Ignore selection in Set

jmmayoral3 — Fri, 30 Jun 2017 06:36:01 GMT

It could be because you are using the "Only" function and you are more than one value in FIELD1toIGNORE and FIELD2toIGNORE fields.

Could you try with other funcion like MAX or MIN and study what happen?

Re: Ignore selection in Set

sunny_talwar — Fri, 30 Jun 2017 13:26:45 GMT

So this goes blank when you make selection in one of these fields?

Field1, Field2, FIELD1toIGNORE, or FIELD2toIGNORE

or does it go blank on fields which are not listed above?

Re: Ignore selection in Set

MK9885 — Fri, 30 Jun 2017 14:10:27 GMT

if Field1 and Field2 are selected it works fine.

But if I select FIELD1toIGNORE, or FIELD2toIGNORE which is not in Set Analysis, it makes the chart disappear.

Re: Ignore selection in Set

MK9885 — Fri, 30 Jun 2017 14:12:08 GMT

Maybe, but I cannot use other than Only.

I do not want to calculate this field.

Dimension here is plain numbers and requirement is not to aggregate it.

Re: Ignore selection in Set

Anil_Babu_Samineni — Fri, 30 Jun 2017 14:12:59 GMT

As Sunny suggestion, Can you try like below

Sum({<Field1=, Field2=, FIELD1toIGNORE=, FIELD2toIGNORE >}Sales)

Re: Ignore selection in Set

sunny_talwar — Fri, 30 Jun 2017 14:20:29 GMT

But you do have them in your expression?

num(only({$<Field1, Field2,FIELD1toIGNORE=,FIELD2toIGNORE=>} Dimension),'#.00%')

What do you mean they are not in set analysis? How else do you add something into set analysis?