Dimension filters - NOT and IS for different tables

[sculptorlv]

Hello again!

I hope you can help me in my work!

I have to ready Straight tables in my qlikview program:

First result table:

Dimension Values

Ru               15

Ru                14

Ru               13

Lv                 11

Second result table:

Dimension Values2

Ru               14

Uk                11

And I have dimension filter for (=List box) like Ru, Uk, Lv etc.

I need to do the following ... as I choose Ru (for examples), in the First result table only Ru dimension values must be left (as usual):

Dimension Values

Ru               15

Ru                14

Ru               13

On the other hand, in the second result table, should be left only values, which are NOT Ru:

Dimension Values2

Uk                11

Any idea how to do it?

Thank you all in advance!

[sunny_talwar]

May be use this set analysis for your second chart's expression:

Sum({<Dimension -= p(Dimension)>} Value)

UPDATE: To help you better, would you be able to share some sample data with the expected output? or may be share a sample application?

[Anonymous]

Give the condition  tab

if(getselectionfield(field),

sum({<e(dimension)>}vaule),

sum(value)