Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning,
I need to include in one document a record number following some criterias. I attached a Excel sheet explaining the topic. If somebody can help me I will appreciate.
Thaanks in advance
Looking into Discussions History I find the solution. You can access to the following link:
http://community.qlik.com/message/1802#1802
Thanks a lot to everybody for your help.
Regards
You can do this in two ways:
1) in the chart by using RowNo() in one expression that numbers rows according to theirs positions.
2) in the script, setting the order and addina a new column with rowno()
hope it helps
Thanks fot your quick response. As you can see if I include the rowno(). Here are the resutls:
WEEK | SKN | Price | CATEGORY | rowno() |
5.415.129 | - | - | ||
9 | 442437 | 465 | 1 | 1 |
9 | 31011 | 1.738 | 1 | 2 |
9 | 335207 | 2.275 | 1 | 3 |
9 | 442445 | 178 | 1 | 4 |
9 | 145734 | 3.685 | 1 | 5 |
9 | 442526 | 49 | 1 | 6 |
9 | 248010 | 284 | 1 | 7 |
9 | 118699 | 1.404 | 1 | 8 |
9 | 442399 | 270 | 1 | 9 |
9 | 565350 | 21 | 1 | 10 |
9 | 134287 | 1.014 | 1 | 11 |
9 | 99570 | 63 | 1 | 12 |
9 | 60240 | 1.781 | 1 | 13 |
9 | 227552 | 1.159 | 1 | 14 |
9 | 315672 | 1.916 | 1 | 15 |
9 | 557137 | 982 | 1 | 16 |
9 | 146854 | 906 | 1 | 17 |
9 | 557013 | 1.079 | 1 | 18 |
9 | 312940 | 1.062 | 1 | 19 |
9 | 676209 | 1.107 | 1 | 20 |
9 | 29726 | 288 | 1 | 21 |
9 | 331902 | 815 | 1 | 22 |
9 | 102261 | 978 | 1 | 23 |
The result is not sorted by 'Price'. Thanks
Yes, it's true,
in the sort tab (properties of the chart) you have to sort by price in descendent order.
I already tested, but when you have a rowno() column and uses the sort by price is not working
You have to sort SKIN (promote it) setting the expression (descending) as sum(price) (if this is the expression you use for price ....
Hope it helps
Hello,
In the sort Tab, sort with 2 criteria :
first the category then the expression you use to calculate the Price ( Sum(Price) for example.
Sorry,
But I don't understand whar do you mind.
I suppose that WEEK and SKN (Not SKIN) are dimensions and Price, Category and RowNo are expressions.
If this is true you have to define the sort criteria.
Go to the sort tab:
1) select SKN and with button promote it to the top, setting the sort criteria with the expression (click the checkbox) and use as expression the same expression you use for price.
2) select other fields in sort tab and uncheck sort criteria
I Hope I have been clear, if not, let me know
It's not working. I have as Dimension SKN, CATEGORY and I sorted by CATEGORY and after SUM(PRICE)