topic Re: Re: Re: Data selection for Charts in QlikView

Data selection for Charts

Fri, 10 Oct 2014 12:49:34 GMT

Hi guys,

following problem:

I want to show the sales revenue of my department in a chart, split up into regions.

I chose a line chart to do so. It gives me one line for each of my three regions.

The problem is that there a revenues that are not assigned to a region (in the data, this field is just empty). How can I include a forth line in my chart, that shows "other region" / "not assigned region"?

I want this chart to be fixed, no matter what region the user selects.

Thanks for your help!

Cheers,
Lina

Re: Data selection for Charts

JonnyPoole — Fri, 10 Oct 2014 12:54:24 GMT

To make it fixed, add a {1} SET STATEMENT into each expression in the chart.

EX: change sum(Sales) to sum( {1} Sales) .

(You would do this in both aggregations in any advanced aggr statements as well (IE: sum( aggr(sum(Sales) , Region)) to sum ( {1} aggr( sum ( {1} Sales),Region)) )

Try to enable 'show all values' on the dimensions on the dimension tab to find the blank/missing bucket of values.

Re: Re: Data selection for Charts

Anonymous — Fri, 10 Oct 2014 12:59:53 GMT

Hi!

Take a look on the attached file!

Regards,

Gabriel

Re: Data selection for Charts

Fri, 10 Oct 2014 13:50:19 GMT

Hey,

thanks for you responses. Unfortunately it is a little bit more complicated.

I attached a file that hopefully helps demonstrate my point:

- The three regions are not identical to the geographic regions, but are emerging market 1, emerging market 2 and developed markets.

- I want to include the last three rows of data as forth line ("other") on my diagram. These are the values that are not assigned to any of the three markets.

I hope someone can help me.

Thanks,
Lina

Re: Re: Re: Data selection for Charts

Fri, 10 Oct 2014 14:08:49 GMT

Hey,

thanks for you responses. Unfortunately it is a little bit more complicated.

I attached a file that hopefully helps demonstrate my point:

- The three regions are not identical to the geographic regions, but are emerging market 1, emerging market 2 and developed markets.

- I want to include the last three rows of data as forth line ("other") on my diagram. These are the values that are not assigned to any of the three markets.

I hope someone can help me.

Thanks,
Lina

Re: Re: Re: Data selection for Charts

JonnyPoole — Fri, 10 Oct 2014 14:29:57 GMT

Those extra data values are not associated to region or zone but they are to year.

In that specific scenario , I wrote this to capture them in the chart. But what about other dimensional contexts ? This may need to be tweaked.

Sum({1<Year=$::Year> - $<Year=,Zone={'Z1','Z2','Z3','Z4','Z5'} >}Data)