topic datamodel& scripting in QlikView

datamodel& scripting

Thu, 14 Aug 2014 12:16:47 GMT

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

Re: datamodel& scripting

Gysbert_Wassenaar — Thu, 14 Aug 2014 12:29:36 GMT

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.

Re: datamodel& scripting

Sat, 16 Aug 2014 07:08:37 GMT

I already do that All actual values present for each year

Re: datamodel& scripting

Sat, 16 Aug 2014 07:49:02 GMT

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

Re: Re: datamodel& scripting

Mon, 18 Aug 2014 05:21:15 GMT

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

Re: datamodel& scripting

ashfaq_haseeb — Mon, 18 Aug 2014 05:44:24 GMT

Hi,

I can't even open this file.

Can you attach a working copy to analyze further.

Regards

ASHFAQ

Re: datamodel& scripting

Mon, 18 Aug 2014 06:10:58 GMT

please download the RAwData.rar file from this link

help

Re: Re: datamodel& scripting

Gysbert_Wassenaar — Mon, 18 Aug 2014 08:21:20 GMT

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

Re: datamodel& scripting

kamalqlik — Mon, 18 Aug 2014 08:27:21 GMT

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