Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

datamodel& scripting

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

8 Replies
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.


talk is cheap, supply exceeds demand
Not applicable
Author

I already do that All actual values present for each year

Not applicable
Author

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

Not applicable
Author

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
Champion III
Champion III

Hi,

I can't even open this file.

Can you attach a working copy to analyze further.

Regards

ASHFAQ

Not applicable
Author

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).


talk is cheap, supply exceeds demand
kamalqlik
Partner - Specialist
Partner - Specialist

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