topic Re: How to detach qlikview with expression in QlikView

How to detach qlikview with expression

Anonymous — Mon, 12 Jun 2017 09:57:02 GMT

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 — Mon, 12 Jun 2017 10:08:31 GMT

May be

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

Anonymous — Mon, 12 Jun 2017 10:14:36 GMT

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 — Mon, 12 Jun 2017 10:21:50 GMT

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

Anonymous — Mon, 12 Jun 2017 10:25:05 GMT

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.

tresB — Mon, 12 Jun 2017 10:28:32 GMT

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 — Mon, 12 Jun 2017 10:29:07 GMT

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 — Mon, 12 Jun 2017 10:34:14 GMT

Would you able to share sample application?