How to get the correct Rowno

[jolivares]

Hi Every one, here you can find out a piece of a chart showing a total qty and other column with the accumulation, everything it's ok, but the order of de RowNo() is incorrect attending to the order.  Let's see

Can someone see the attached qvw in order to get the correct solution?... Thamks.

gwassenaar‌

[Anonymous]

p.s. I understand this is a SQL issue but is there a way to handle this in QlikView.

Laura Castagna

Business Systems and Process Analyst, NSW Business Chamber

140 Arthur Street North Sydney NSW 2060

Tel: 02 9458 7804 | Mob: 0429 486 934 | Web: www.nswbusinesschamber.com.au<http://www.nswbusinesschamber.com.au>

Twitter<http://www.twitter.com/nswbc> | Facebook<https://www.facebook.com/NSWBusinessChamber> | LinkedIn<http://www.linkedin.com/company/388425?trk=saber_s000001e_1000> | YouTube<http://www.youtube.com/nswbctv>

<http://www.nswbusinesschamber.com.au/>

Proud supporter of:

<http://acci.headsup.org.au/>

[hic]

Remove the Join from the script. Then the calculations will (probably) be correct.

HIC

[Anonymous]

I cant as I need a field from that table.  the "at_fault" field.

[flipside]

What are you trying to return from the training_contract_returns table? That table must contain multiple entries for the training_contract_id value which is why duplicates are being returned. You need to decide which of these multiple values you need (max, min, first, last etc)..

flipside

[Anonymous]

could well duplicated in the TrainingReturns table.  its a tricky table to query as there are no parameters for me to use to check for duplications!  I'd have to go through each consultant which would take me forever.

I only need a count of contracts so I can take the first or second. 

[Anonymous]

I'm trying to return the "contract" count so it doesn't matter if the first or second is counted.  I've tried this without success but maybe its bc i dont know how......is there a way of counting "distinct" rows based on a field in QlikView.

For example,  can i count a field with a Distinct function in the expression OR in the Load?

[hic]

If you need a field from an other table, you could use Applymap(). See Don't join - use Applymap instead.

HIC

[flipside]

[jolivares]

Thanks for your comments, just think that muy question is not answer yet and every day I receive an update about this case that is not my case.

[flipside]