topic Re: Re: Re: Re: Re: help in QlikView

help

Thu, 14 Aug 2014 06:50:39 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

Re: help

tresB — Thu, 14 Aug 2014 07:03:47 GMT

It leads you to comprehend that, the specific field value has no values in other field against it. This could happen if you join tables in the script.

Re: help

Thu, 14 Aug 2014 07:07:19 GMT

how to resolve it

Re: Re: help

Thu, 14 Aug 2014 07:09:35 GMT

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: help

ashfaq_haseeb — Thu, 14 Aug 2014 07:11:55 GMT

Hi,

It could happen if the is no association or logical connection between the two fields.

Regards

ASHFAQ

Re: help

Thu, 14 Aug 2014 07:29:37 GMT

they both are present in same table

Re: help

ashfaq_haseeb — Thu, 14 Aug 2014 07:32:30 GMT

Hi,

Attaching sample data would really help.

Regards

ASHFAQ

Re: help

Thu, 14 Aug 2014 12:33:06 GMT

You need modify the table structure while loading the data table. I suggest load these 2 fields into separate table along with key field. Please find the below :

Main Table: KEY, A, B, C, D, E

I want break the association b/n D, E.

MainTable:

LOAD KEY, A, B, C, D, E FROM TABLE;

NewTable:

LOAD DISTINCT KEY, D AS NEW_D , NULL() AS NEW_E Resident MainTable;

LOAD DISTINCT KEY, Null() AS NEW_D , E AS NEW_E Resident MainTable;

Drop Fields D, E ;

Re: Re: help

Mon, 18 Aug 2014 05:27:25 GMT

see the attachment

It will give zero on year selection

Re: help

ashfaq_haseeb — Mon, 18 Aug 2014 05:32:19 GMT

I try to download the attachment.

I think its corrupted I could not open it.

Could you attach it again.

Regards

ASHFAQ

Re: help

sujeetsingh — Mon, 18 Aug 2014 05:39:13 GMT

They are missing or nulls

Re: Re: help

Mon, 18 Aug 2014 05:52:30 GMT

pfa

Re: Re: Re: help

Mon, 18 Aug 2014 05:59:05 GMT

pfa

Re: help

ashfaq_haseeb — Mon, 18 Aug 2014 06:04:48 GMT

Hi,

I'm sorry but still I could not open it.

Can you add a drop box link if possible.

Regards

ASHFAQ

Re: Re: Re: Re: help

Mon, 18 Aug 2014 06:06:41 GMT

or try this

Re: Re: Re: Re: Re: help

ashfaq_haseeb — Mon, 18 Aug 2014 06:21:35 GMT

Hi,

Yes I can open it now.

What are you trying to achieve here.

Is that what you wan't. have a look at attached image.

Regards

ASHFAQ

Re: Re: Re: Re: Re: help

Mon, 18 Aug 2014 06:26:55 GMT

By mistake i have added HSL in dimension ,it should be sum(HSL) in the expression

Please rectify it.

My problem is ,if i check the value in table box HSL value present for each year

But once i create chart ,it wont display the result

Re: help

Mon, 18 Aug 2014 06:28:22 GMT

yes,how u do that

Re: help

ashfaq_haseeb — Mon, 18 Aug 2014 06:37:04 GMT

Hi,

By using this expression.

=sum(fabs(HSL))

I have converted all negative values to positive.

Is o/p correct can you confirm the same from your source.

Regards

ASHFAQ

Re: Re: Re: Re: Re: help

Mon, 18 Aug 2014 06:37:23 GMT

tell me plz