data in table but now flowing through to dashboard

[Anonymous]

hi,

the following data is a snap shot from the qlikview table.   the second snapshot shows that the Contract are loading but not the Returns (i.e. ConType in table).  How can I trouble shoot as to why the data is not coming through.  I have used Sum(AtFaults) in the expression.

[qlikviewwizard]

Hi Laura,

Can you attach the sample file to demonstrate your issue? It will be easy for us to provide the solution quickly.

[Anonymous]

sure.  sorry but do you mean a sample file of the tables? or the script?

[Anonymous]

how can I extract a sample of what's in the table?

[qlikviewwizard]

Attach the sample file is better.

[Anonymous]

Hi Arjun,

file sample attached for data not flowing into dashboard.

cheers

[qlikviewwizard]

Hi Laura,

Excel file contains only for May-2015.

what is the formula for Contract and Returns? I used for count(some dimension).

You can run with the original data file. Hope this will help you.

[nizamsha]

Laura

1)As of my understanding Date field from first table start from apr to sep correct

2) we have a contract for the apr to sep

3) we dont have a return for apr to sep

check is that correct

sum({$<Type={"Contract"}>}contract)

sum({$<Type={"Return"}>}ATFault)

[Anonymous]

Hi Nizam,

tried it but no luck.

[Anonymous]

the sample file attached shows that the data for Returns exists (i.e. contractType) but i still can't  get it to populate through to dashboard/