Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

help

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

1 Solution

Accepted Solutions

Re: help

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

23 Replies
MVP
MVP

Re: help

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.

Not applicable

Re: help

how to resolve it

Not applicable

Re: Re: help

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

Hi,

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

Regards

ASHFAQ

Not applicable

Re: help

they both are present in same table

Re: help

Hi,

Attaching sample data would really help.

Regards

ASHFAQ

Not applicable

Re: help

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 ;

Not applicable

Re: Re: help

see  the attachment

It will give zero on year selection

Re: help

I try to download  the attachment.

I think its corrupted I could not open it.

Could you attach it again.

Regards

ASHFAQ

Community Browser