topic Re: Chart values population in QlikView

Chart values population

Anonymous — Thu, 22 Sep 2016 20:24:55 GMT

I have a Excel with 22 Columns, in that I need 14 columns to build my chart and one of the 14 columns is my dimension. All the remaining will be used for generating my bar graph.

I tried using Only() for all the columns which I am trying to populate and it's not working.

Any suggestions?

TIA

Re: Chart values population

swuehl — Thu, 22 Sep 2016 21:57:46 GMT

Only() in your expression will only work if the argument to Only() returns a single value in the aggregation scope (basically the scope of the dimension(s)) using the record set that is filtered by your selections.

If there are more than 1 possible value to be returned, Only() will return NULL.

Then you need to consider another aggregation function.

Try Sum(), Count(), Concat() etc.

Use Aggregation Functions!

The Aggregation Scope

Re: Chart values population

MarcoWedel — Thu, 22 Sep 2016 23:05:51 GMT

13 Excel columns delivering values for a bar chart (one column for one bar each?) sounds like a use case for

The Crosstable Load

hope this helps

regards

Marco

Re: Chart values population

Anonymous — Fri, 23 Sep 2016 13:24:32 GMT

I want everything as a stacked bar chart. As a combination of bar graph and line graph.

TIA

Re: Chart values population

Anonymous — Fri, 23 Sep 2016 13:24:56 GMT

Stacked together.