topic Re: Combo chart in QlikView

Combo chart

bharatkishore — Wed, 10 Aug 2016 06:55:54 GMT

Hi All,

I took a combo chart and took dimension as Month and Traffic source.

I have given the expression is =sum(CCF)/sum(TOTAL {<S5_Traffic_Source=>} CCF)

Now the problem is the expression is working fine when i select all the filters.But when i keep the same in chart the values are changing attached images for your reference.

Thanks

Bharat

Re: Combo chart

sunny_talwar — Wed, 10 Aug 2016 07:34:44 GMT

I am not sure I understand. Do you want your chart to change based on selection or you don't want it to change?

Re: Combo chart

bharatkishore — Wed, 10 Aug 2016 09:03:33 GMT

it should not change Sunny...The value should be 30.91.

please let me know if you need anything more.

Re: Combo chart

sunny_talwar — Wed, 10 Aug 2016 09:05:58 GMT

I guess it would be helpful if you can provide a sample as I am still not sure what part of the selection is changing.

Re: Combo chart

bharatkishore — Wed, 10 Aug 2016 09:22:11 GMT

Thanks Sunny for your reply..

I figured it out by giving this expression

=sum(CCF)/sum(TOTAL<S5_Month> CCF)

Thanks a lot...

Re: Combo chart

sunny_talwar — Wed, 10 Aug 2016 09:23:50 GMT

But this won't ignore any selection. I thought you wanted to ignore selections

Re: Combo chart

ThornOfCrowns — Wed, 10 Aug 2016 09:34:10 GMT

Two things:

Your answer doesn't do what your question asked
You have marked your own answer as correct - see (1)

Re: Combo chart

bharatkishore — Wed, 10 Aug 2016 09:48:24 GMT

May be my explanation is wrong but these are the values what i wanted..

Thanks

Bharat

Re: Combo chart

bharatkishore — Wed, 10 Aug 2016 09:48:49 GMT

I m sorry Sunny may be my explanation is wrong..