topic Table to not be affected by some fields in QlikView

Table to not be affected by some fields

Thu, 06 Feb 2014 14:18:03 GMT

Hey guys,

I have a straight table, and I have a field that i want to click on that and this table doesn't not get affected by using this field. How can I do that??

Re: Table to not be affected by some fields

Anonymous — Thu, 06 Feb 2014 14:44:53 GMT

Julio,

I can do it by using set analysis. In each expression of the table, make a change like this:

from

=sum(Value)

=sum({<"this field"=>} Value)

Re: Table to not be affected by some fields

marcus_sommer — Thu, 06 Feb 2014 14:45:19 GMT

You need a set analysis statement within your expressions - sum({1} VALUE).

- Marcus

Re: Table to not be affected by some fields

Thu, 06 Feb 2014 14:47:41 GMT

Whatever fields you are using in the Straight table, you can make a Data Island of that i,e a separate data table which is not linked to rest of the tables.

or another thing is,using macro, on selecting a field, you can disable and enable a chart.(though i am not that good in macros and are not recommended)

Thanks,

Angad

Re: Table to not be affected by some fields

Thu, 06 Feb 2014 16:29:05 GMT

I didn't work quite fine for me, because one of the fields is text, so, i don't know why, but set analysis doesn't work fine. I managed by creating an alternate state for that specific field, and the next straight table i'll do in this state, but i still didn't like this way of solving it...

Re: Table to not be affected by some fields

Anonymous — Thu, 06 Feb 2014 16:32:42 GMT

There could be reasons for it not working, but the text should be a problem - use expression with only()

=sum({<"this field"=>} TextField)

Re: Table to not be affected by some fields

Thu, 06 Feb 2014 16:54:42 GMT

=({<"this field"=>} TextField)

like this? didn't work... it says "Error in the expression...

Re: Table to not be affected by some fields

Anonymous — Thu, 06 Feb 2014 16:56:20 GMT

Sorry, typo:

=only({<"this field"=>} TextField)

Re: Table to not be affected by some fields

Thu, 06 Feb 2014 17:00:39 GMT

aeouihaohuaohuaeohuaoha, now It worked, kkkkkkkk, thank you alot