
Re: Compare sum of rows of column 1 with sum of rows column 2 in straight table with dimension limits
Marcus Sommer Feb 5, 2015 3:02 PM (in response to Jeroen Jordaan )I assume you will need some kind of calculated aggregation with aggr() and/or the TOTALqualifier instead the TotalMode of the table, see here various examples:
http://community.qlik.com/search.jspa?q=straight+table+total+aggr&type=document
 Marcus

Re: Compare sum of rows of column 1 with sum of rows column 2 in straight table with dimension limits
Jeroen Jordaan Feb 5, 2015 3:42 PM (in response to Marcus Sommer )Hi Marcus,
Thanks for your reply.
I cannot see how I can combine the total of the whole with the total of the Top 10 in one column of the straight table.
Do you have an idea?


Re: Compare sum of rows of column 1 with sum of rows column 2 in straight table with dimension limits
Jeroen Jordaan Feb 6, 2015 5:48 AM (in response to Jeroen Jordaan )I hope someone has an idea

Re: Compare sum of rows of column 1 with sum of rows column 2 in straight table with dimension limits
Nandkishor Pandirkar Feb 6, 2015 6:01 AM (in response to Jeroen Jordaan )Hi,
I think you can use if statement like
if(rowno()=0, your custom expression to get outcome of 172 ,Index LYTD) in your expression.
rowno()=0 will check whether the current row is total row or not
Regards
Nandkishor

Re: Compare sum of rows of column 1 with sum of rows column 2 in straight table with dimension limits
Jeroen Jordaan Feb 6, 2015 6:34 AM (in response to Nandkishor Pandirkar)Hi Nandkishor,
Thanks for your idea but unfortunately is does not work.
I think it doesn't identify de total of the top 10 as RowNo 0

Re: Compare sum of rows of column 1 with sum of rows column 2 in straight table with dimension limits
Nandkishor Pandirkar Feb 6, 2015 6:40 AM (in response to Jeroen Jordaan )Can u provide me the sample qvw and expression so that I can try it out

Re: Compare sum of rows of column 1 with sum of rows column 2 in straight table with dimension limits
Marcus Sommer Feb 6, 2015 6:54 AM (in response to Jeroen Jordaan )nandkishor pandirkar is right you will need to use an expression which queries the rowno and the differ the calculation. Important is that you couldn't use the inbuild qvfunctionalities for top  you will have to create this with a calculated dimension with hidden nullvalues like:
= if(aggr(rank(sum({< Year = {2013}>} Sales)), item)<=10, Item)
and then use expressions like:
if(rowno() = 11, sum({1< Year= {2014}>} total Sales),
sum({< Year= {2014}>} Sales)) /
if(rowno() = 11, sum({1< Year= {2013}>} total Sales),
sum({< Year = {2013}>} Sales))Of course you could make these expressions with Year = {"$(=max(year)1)"} and/or variables for rowno() and rank dynamically.
 Marcus


Re: Compare sum of rows of column 1 with sum of rows column 2 in straight table with dimension limits
Jeroen Jordaan Feb 6, 2015 7:02 AM (in response to Nandkishor Pandirkar)Hi Nandkishor,
I said that your RowNumber idea didn't work but I did something wrong so it did work.
Thank you very much for your help.
@Marcus
Thank you also for your help.

