Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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?
Give the condition tab
if(getselectionfield(field),
sum({<e(dimension)>}vaule),
sum(value)