topic Re: Data not populating in the chart. in QlikView

Data not populating in the chart.

Anonymous — Wed, 21 Sep 2016 19:29:55 GMT

I have 4 columns consisting of 32 rows each. I need all of these values to be populated on a Bar chart. I have tried using Only(column_name), but it says 'No data to display'. Is there something I am missing here? How can I populate the values of all the rows of the 4 columns?

TIA

Re: Data not populating in the chart.

sunny_talwar — Wed, 21 Sep 2016 19:48:26 GMT

What is within those columns? Can you share few rows of data for the four columns? Also why use Only(), do you have all those 32 rows as the same number? May be use Max or Min or Sum or Avg?

Re: Data not populating in the chart.

Anonymous — Wed, 21 Sep 2016 20:02:13 GMT

This is how the data looks(part of it)

0	0	2	0
0	0	0	2
0	0	0	0
0	0	4	0
0	0	0	0
0	0	0	0

Re: Data not populating in the chart.

sunny_talwar — Wed, 21 Sep 2016 20:09:04 GMT

Have you tried Sum(Column_Name)

Re: Data not populating in the chart.

Anonymous — Wed, 21 Sep 2016 20:11:15 GMT

We only need the bar chart to be populated with the values. Not based on the Sum of the values.

Re: Data not populating in the chart.

Anonymous — Wed, 21 Sep 2016 20:22:48 GMT

Hi try this

Rangesum(column1,column2,column3,column4)

Re: Data not populating in the chart.

Anonymous — Wed, 21 Sep 2016 20:26:59 GMT

Nope, Not working.

I do not want any type of Sum. I just want to populate my chart based on the values.

Re: Data not populating in the chart.

el_aprendiz111 — Wed, 21 Sep 2016 20:36:31 GMT

Hi,

sum(Aggr(sum({<column_name={'*'}>}column_name1),column_name))

Re: Data not populating in the chart.

sunny_talwar — Wed, 21 Sep 2016 20:47:58 GMT

What is your dimension here? Or do you not have a dimension? If you don't then this isn't going to work.

May be create a dimension when loading the data

LOAD RowNo() as Dim,

Column_Name1,

Column_Name2,

Column_Name3,

Column_Name4

From ....;

And then use Dim as your dimension and Only(Column_Name1) as expression

Re: Data not populating in the chart.

Anonymous — Wed, 21 Sep 2016 20:48:35 GMT

Hello,

I am not looking for any type of Sum formula/expression to populate the chart. I just want to populate based on the values.

Re: Data not populating in the chart.

Anonymous — Thu, 22 Sep 2016 13:17:37 GMT

No, No luck.

So I have total 7 Columns but I want the data from only 4 particular columns to be populated in the bar chart. No sum nothing. Just the data to be populated. As you suggested we tried loading RowNo() as dim... but that is not working too.

Have a look at the screenshot I am attaching

Re: Data not populating in the chart.

sunny_talwar — Thu, 22 Sep 2016 16:25:38 GMT

What is the exact issue you are running into? You seem to have a lot of 0s, have you unchecked 'Suppress Zero Values' on the presentation tab of your chart properties?

Re: Data not populating in the chart.

Anonymous — Thu, 22 Sep 2016 16:32:18 GMT

I got what I was looking for. I used CrossTable to convert rows to columns and able to generate the chart as needed.

Thanks

Re: Data not populating in the chart.

nagarjuna_kotha — Thu, 22 Sep 2016 16:39:39 GMT

Can u provide sample data , then we can try on it.

Re: Data not populating in the chart.

nagarjuna_kotha — Thu, 22 Sep 2016 16:40:53 GMT

assuming in the air, will not give proper output to u. 😉

Re: Data not populating in the chart.

Anonymous — Thu, 22 Sep 2016 16:44:56 GMT

Hello Nagarjuna,

I got what I was looking for. I cross checked the chart selections and the graphs with my excel and it is working fine. Just had to use a different perspective.

Anyway thanks for the help.

Re: Data not populating in the chart.

Anil_Babu_Samineni — Thu, 22 Sep 2016 17:09:47 GMT

Let's Assume, if you have Data like below

Load * Inline [

Sales, Name, Company

1, A, X

2, B, Y

3, C, Z

4, D, P

];

While you are using Bar Graph Company as Dim

Expression as Sum, Max, min, Avg

Then you will go to mouse over then it will show those aggr functions on your pop-up. That you are looking or else.