Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to detach qlikview with expression

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)


Chart.jpg

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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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)

View solution in original post

7 Replies
MK_QSL
MVP
MVP

May be

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

Anonymous
Not applicable
Author

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.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

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
MVP
MVP

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
MVP
MVP

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?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful