how to get bar chart to display all Dimension values

[gerrycastellino]

I need to display all values as visible in the raw data. 'A' / 'B' values are missing from bar chart.

I cannot have the expression sum up the values,  just a simply display in bar chart format.

[robert_mika]

Change expression to

sum(DaysOpen)

Feeling Qlikngry?

How To /Missing Manual(23 articles)

[gerrycastellino]

I would like to see the 2 two individual values for 'A'  as 2 bar lines, not summed up ...

[sunny_talwar]

What are you looking for? Sum, Avg? You should Just the field name itself won't work here

[sunny_talwar · Accepted solution]

May be like this?

Script Changes:

LOAD *,

  If(Previous(Ticket) = Ticket, RangeSum(Peek('Key'), 1), 1) as Key;

load * Inline [

Ticket, DaysOpen, cnt

A,  10, 1

A,  20, 2

B,  10, 3

B,  20, 4

C,  10, 5

D,  20, 6

E,  30, 7

];

Chart Changes:

Added Key as second dimension

[gerrycastellino]

not sum or average, just a dump of the data into the bar chart by daysopen.

[robert_mika]

Did you check my solution?

Does it work for you?

Feeling Qlikngry?

How To /Missing Manual(23 articles)

[HirisH_V7]

Hi ,

Hope this is what you required,

In Style -> Keep Sub Type -> Grouped Checked

or

Else another Chart

Dimension:

Ticket

DaysOpen

Expression:

DaysOpen

Hope this Helps,

Regards,

HirisH

[tresesco]

Little easier ! PFA

[gerrycastellino]

nice !  I like it ....