topic Re: Data present in database but not shown in chart in QlikView

Data present in database but not shown in chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Data present in database but not shown in chart

MK9885 — Wed, 06 Dec 2017 18:18:22 GMT

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?

Re: Data present in database but not shown in chart

vishsaggi — Wed, 06 Dec 2017 18:20:40 GMT

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?

Re: Data present in database but not shown in chart

Anonymous — Wed, 06 Dec 2017 18:50:54 GMT

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.

Re: Data present in database but not shown in chart

Anonymous — Wed, 06 Dec 2017 18:51:48 GMT

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

Re: Data present in database but not shown in chart

MK9885 — Wed, 06 Dec 2017 19:03:59 GMT

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

Re: Data present in database but not shown in chart

Anonymous — Wed, 06 Dec 2017 19:21:01 GMT

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

Re: Data present in database but not shown in chart

MK9885 — Wed, 06 Dec 2017 19:26:06 GMT

Ok thanks.

Hopefully anyone else can help you without either.

Re: Data present in database but not shown in chart

vishsaggi — Wed, 06 Dec 2017 19:26:25 GMT

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.

Re: Data present in database but not shown in chart

Anonymous — Wed, 06 Dec 2017 19:30:21 GMT

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

Re: Data present in database but not shown in chart

Anonymous — Thu, 07 Dec 2017 04:32:46 GMT

yes i check, in database it shows 200 but in list box it shows 0.

now what should i do?

Re: Data present in database but not shown in chart

Anonymous — Thu, 07 Dec 2017 04:35:47 GMT

now i check with other filter it show some count for that category.

Re: Data present in database but not shown in chart

Anonymous — Thu, 07 Dec 2017 04:47:11 GMT

there is no negative value

Re: Data present in database but not shown in chart

Anonymous — Thu, 07 Dec 2017 04:57:58 GMT

DIM:

=If(YEAR=(GetFieldSelections(YEAR,'', '', 'Chart 4') -2), YEAR)

EXP:

=Sum({<SUBJECT=$::SUBJECT, KPI=$::KPI, REGION=$::REGION, CATEGORY=$::CATEGORY, KPI={'PRODUCTION'}, SUB_AREA={'ABC'}, YEAR={">=$(=vYearChart4Start) <=$(=vYearChart4End)"}>}VALUE)/1000

and one thing i just check ,in database there are 200 rows but in list box it shows 0 and on other filter it shows 360 value

Re: Data present in database but not shown in chart

Anonymous — Thu, 07 Dec 2017 05:55:14 GMT

Atleast post expression here we willl check once.

Re: Data present in database but not shown in chart

Anonymous — Thu, 07 Dec 2017 05:56:19 GMT

i already post it

Re: Data present in database but not shown in chart

krishna20 — Thu, 07 Dec 2017 06:51:25 GMT

Hi Dhok,

First of all back trace the data from qlikview to DB.

Take corresponding qvd and test the data in another qvw file.

If you are getting the data in qvd. Go to your datamodel qvw file and check.

If you are not getting the data in your datamodel, then there will be some mapping gone wrong.

If you are getting data in datamodel also, we need to check your expression.

Try the above steps and let us know.

Re: Data present in database but not shown in chart

Anonymous — Thu, 07 Dec 2017 06:59:14 GMT

All are done properly. There is only issues in expression

Re: Data present in database but not shown in chart

vishsaggi — Thu, 07 Dec 2017 12:14:44 GMT

Can you share that sample file you are facing issues with? Would be easy to work on..

Re: Data present in database but not shown in chart

Anonymous — Thu, 07 Dec 2017 12:40:59 GMT

sorry i cant share