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

[Anonymous]

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

now what should i do?

[Anonymous]

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

[Anonymous]

there is no negative value

[Anonymous]

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

[Anonymous]

Atleast post expression here we willl check once.

[Anonymous]

i already post it

[krishna20]

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.

[Anonymous]

All are done properly. There is only issues in expression

[vishsaggi]

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

[Anonymous]

sorry i cant share