How to detach qlikview with expression

[Anonymous]

Good Noon Everyone,

Today I wanted to detach one of my charts permanently.

For which I created a Bar chart.

Dimension: Month

Expression: =Aggr((Count(GID3)-Count(DISTINCT GID3))/Count(GID3),Month1)

How will I set expression in the above expression so that it get detached permanently?

[MK_QSL]

May be

=Aggr((Count({1}GID3)-Count({1}DISTINCT GID3))/Count({1}GID3),Month1)

[Anonymous]

Its not working ,

when i click on any month of the chart its change accordingly.

So i don't what that. it must not change.

[Anil_Babu_Samineni]

I assume, You have to write {1} for all expressions. Not only for one expression.

[Anonymous]

Ok Anil,

But assume I have only one expression, My dimension is Month and expression is

=Aggr((Count({1}GID3)-Count({1}DISTINCT GID3))/Count({1}GID3),Month1)

but still, it changes with the selection of the month.

[tresesco]

Are Month and Month1 different? Can't you just remove aggr() and just try expression like?

=Count({<Month1>}GID3)-Count(DISTINCT {<Month1>} GID3))/Count( {<Month1>} GID3)

[MK_QSL · Accepted solution]

Try this

=Only({1}Aggr((Count({1}GID3)-Count({1}DISTINCT GID3))/Count({1}GID3),Month1))

or simply

Count({1}GID3)-Count({1}DISTINCT GID3))/Count({1}GID3)

[Anil_Babu_Samineni]

Would you able to share sample application?