topic Re: Help post for Combo Chart in QlikView

Help post for Combo Chart

Anonymous — Thu, 11 May 2017 07:20:33 GMT

Hi, i'm facing some problem in my qlikview Combo chart design.

In my design, x-axes will be show week number and y-axes Sales Value.

X-axes is ok, but Y-axes show two value, one value i mean Bar is ok but Line not show anything.

1. Bar: Current year total value like sum(Sales) .

2. Line: Last Year Total Sales. so expression definition i'm using this expression: if(Year=2016,sum(sales))

but no result. So may i asked you my expression is right ?

Could you please help them ??

Re: Help post for Combo Chart

Anonymous — Thu, 11 May 2017 16:11:20 GMT

Try

if(Year=2016,sum(sales),)

sum({<Year={'2016'}>}Sales)

Re: Help post for Combo Chart

Anil_Babu_Samineni — Thu, 11 May 2017 16:35:19 GMT

May be these?

For Bar chart & Line chart expressions are

1) Sum({<Year = {'$(=Max(Year))'}>}Sales)

2) 1) Sum({<Year = {'$(=AddYears(Max(Year),-1))'}>}Sales)

Re: Help post for Combo Chart

Anonymous — Sun, 14 May 2017 05:37:24 GMT

Big thanks to all of you ...

Re: Help post for Combo Chart

oknotsen — Sun, 14 May 2017 18:31:15 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .