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: 
Not applicable

Having total of charts line into the axis?

Hello,

Is it possible to have a graph with total into the axis like this ( but "0" replace by the total of the line):

2012-08-10_093256.png

I have 3 dimesions: Date_Creation, Type_Opération_GRP and Type_Opération.

Expressions are:

1- "Nbre Log" =if(inweek(Date_Creation,today(),0) or inweek(Date_Creation,today(),-1), count(distinct ID))

2- "" =sum([Nbre Log]),  to have the total on axis with checked box "text on axis"

2012-08-10_094103.png

Thanks in advance for your help

Laurent

Edit: I've made this in 2nd expression in pop-pup and text on axis:

=sum(distinct if(inweek(Date_Creation,today(),0) or inweek(Date_Creation,today(),-1),aggr(count(total<Type_Opération_GRP,Date_Creation> ID),Type_Opération,Type_Opération_GRP,Date_Creation)))

It works but seems encounter a bug: The obtained value for 1st value of the 3d dimension is repeated for each distinct name of the field on 3d dimension (here "Type_Operation") to others lines an over value. For others, lines there is no duplicate. See screen shot below for example:

2012-08-10_145108.png

The value in pop-up is good vs "text on axis" (duplicated on other lines for first value)

0 Replies