topic Combo Chart in QlikView

Combo Chart

seahyanzheng — Sat, 06 Jan 2018 13:49:04 GMT

Hi,

May i know why my combo chart looks like this after i restrict largest 10 in the dimension using the first expression and promoted the calculated expression to the first.

Otherwise, it looks like this but the sequence (4th bar changed) is not what i desire:

Re: Combo Chart

Anil_Babu_Samineni — Sat, 06 Jan 2018 13:50:48 GMT

Can you share sample test? Not sure, How you written the expression

Re: Combo Chart

seahyanzheng — Sat, 06 Jan 2018 14:17:40 GMT

Hi,

I have one dimension - Branch and three express - sum(Case Count), sum(Branch UL Target) and sum([Case Count])/sum([Branch UL Target]). After i restrict to top 10 and promote sum([Case Count])/sum([Branch UL Target]) to the first expression, the chart looks like the first picture and when sum(case count) is in the first expression, it looks like the second pic.

Re: Combo Chart

seahyanzheng — Sat, 06 Jan 2018 14:43:49 GMT

Hi,

Have changed from largest ten to first ten and it works fine.

Thanks Anil!

Re: Combo Chart

Anil_Babu_Samineni — Sat, 06 Jan 2018 15:09:04 GMT

Hahaha