topic Dimensions Do Not Work As Expected When Graph Has 'P' Possible Data in QlikView

Dimensions Do Not Work As Expected When Graph Has 'P' Possible Data

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

I have a graph using expressions with the 'P' function but when I try to filter one of the dimensions it does not work.

I'll send a small application in attach that if you select 1 value in the LOV should filter and show in the graph only the line with this value.

Additionally i also intended that only the available values (using the same "P" function) in the LOV? it's possible ?

Thank you in advance for your help.

Ricardo

sunny_talwar — Thu, 11 May 2017 15:32:09 GMT

May be remove 1 within the P()

=Sum({$<FactKey={"R1"}, Cod = P({<FactKey={"R2"}>} Cod)>} Value)

swuehl — Thu, 11 May 2017 15:32:22 GMT

Try the intersection operator *

=sum( {$<FactKey={"R1"},Cod *= P({1<FactKey={"R2"}>} Cod)>} Value )

swuehl — Thu, 11 May 2017 15:34:22 GMT

And as list box field expression:

=Aggr( Only({1<FactKey={"R1"},Cod = P({1<FactKey={"R2"}>} Cod)>} Cod), Cod)

Anonymous — Thu, 11 May 2017 15:45:36 GMT

Both (3) the answers are correct, but Stefan Wühl as answered the 2 I give him the points of the correct answer.

Thank you very much.

sunny_talwar — Thu, 11 May 2017 15:47:51 GMT