Data present in database but not shown in chart

[Anonymous]

Hello everyone

I have one issue and want to resolve at high priorty .

I have one list box Category which is contain four value like A,B,C,D. While i click on B,C,D its shows value in Chart and when i click on A it shows "No Data Display" but that data available in database.

I cross verify the expression but i am not getting where i get stuck.

Please help me to find out.

Thank you

[MK9885]

I guess it is your expressions which is disabling the values related to A.

What's your expression and what is the result you expect for your values?

[vishsaggi]

Can you count the rows that of SQL and Qlikview. Like how many rows you are getting through SQL and how many after you load in Qlikview?

[Anonymous]

No there is no any categories value in expression. I used set expression. When i select categories it will show product as well as sales value in pie chart.

[Anonymous]

In sql it shows many rows but in pie chart it shows nothing

[MK9885]

Can you share a sample app or sample data with your dimension(s) and expression?

[Anonymous]

Tomorrow I will share exp and dim but i cant share app or data

[MK9885]

Ok thanks.

Hopefully anyone else can help you without either.

[vishsaggi]

I mean did you check the rows in SQL Like for eg in your sql query you got 50000 rows. Are you getting the same count when you load in Qlikview. Use RowNo() AS Rows in your Load script and in your text object write like = Count(Rows) see how many you are getting.

[Anonymous]

If the value is negative then pie chart won't show the data .try to check the output manually once