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‌

[marcus_sommer]

Sorting will be by design disabled if inter-record functions are used, see: Re: Interactive sort not working when using RowNo() for coloring alternative rows in straight table.

- Marcus

[jolivares]

I already have the correct rowno but no the expected result accumulating the QTY in the correct order.

[petter]

I am sorry but I don't catch what your problem is. Could you give us more details?

Is it interactive sort or is it how the calculations are ordered or carried out or is it in the sums you are getting.

If you could give us an example of what is wrong and what should be the right...

[hic]

If you want the accumulated number of Sum(QTY), you should get rid of all the Aggr() functions and instead use

   RangeSum(Above(total Sum(QTY),0,RowNo(total)))

HIC

[jolivares]

Thanks for your question.  I'm not worried about the interactive sort, the problem is the order of the accumulation.

Feel free and see the new file attached and inside I explain better the require.

[Anonymous]

Hi Henric,

am I able to add a question to you directly?

Laura

[hic]

Just send me a message here on QlikCommunity

HIC

[jolivares]

May you ckeck the last post of the file, the last answer you gave me no does not work.

Or it something that QV no mange? Exist a workaround to solve it?

Thanks.

[Anonymous]

Hi Henric,

I am still struggling to understand why I am getting duplicates and how I can overcome this issue.

I have trouble shooted this in SQL and I found the duplication of records (very few) occurs due to the link between the “training_contracts” and “training_contract_returns” tables.When I remove “training_contract_returns” from the sql, there are no duplications.

I think the issue is this……there is only one field in the “training_contract_returns” (id), that I can use to link to other tables:-

How can I tackle this situation?

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/>