datamodel& scripting

[#1]

if two field  present with in the table but if i select one field  it didn't show any association in other(means if i select a value from one field all the value in  other field turns gray

what to do in this case

E.g.

Fiscal Year_GHAJR and AmountInLC_Actual present in the same table and fiscal year present in FiscalCalender table

in the front end gross revenue is the calculated dimension and summation of all the above dimension but it won't display ,if i make a selection on Fiscal Year_GHAJR field although they present in the same table

see the attachment for datamodel

[Gysbert_Wassenaar]

Check the data. If you have two fields in the same table and you select a value in the first field then if all the values of the other field turn gray that means you have null values in your table in that field. Try adding the fields to a table box object, make your selection selection and see what values exists in the other fields.

[#3]

I already do that All actual values present for each year

[#4]

if I create  a pivot chart with Fiscal_Year _GJAHR as dimension and sum( AmountInLC_Actual) as expression

It only display the value for the year 2014

but if i select 2011,2012,2013 or 2010 it  give zero value ,even though the values are present for all the field as display in table box

[#5]

hi Gysbert,

I have done testing of my application ,I have commented all the code except table which having GJAHR &HSL field .But still i display the same result even though the datamodel just having only one table with three field

problem is whenever i create  GJAHR Field & and hsl  chart it display 0 result.See the attachment

[ashfaq_haseeb]

Hi,

I can't even open this file.

Can you attach a working copy to analyze further.

Regards

ASHFAQ

[#7]

please download the RAwData.rar file from this link

help

[Gysbert_Wassenaar]

Qlikview is case sensitive. That means that HSL and hsl are two different fields to Qlikview. Try sum(HSL) instead of sum(hsl).

[kamalqlik]

Hi Shweta,

Please attach your QVW here.so I can look after it.

I am not able to open the QVW that you have uploaded above.

Regards

Kamal