Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

bharatkishore
Contributor III

Combo chart

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

1 Solution

Accepted Solutions
bharatkishore
Contributor III

Re: Combo chart

Thanks Sunny for your reply..

I figured it out by giving this expression

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

Thanks a lot...

8 Replies

Re: Combo chart

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

bharatkishore
Contributor III

Re: Combo chart

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

please let me know if you need anything more.

Re: Combo chart

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.

bharatkishore
Contributor III

Re: Combo chart

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

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

thornofcrowns
Valued Contributor II

Re: Combo chart

Two things:

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

bharatkishore
Contributor III

Re: Combo chart

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

Thanks

Bharat

bharatkishore
Contributor III

Re: Combo chart

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

Community Browser