topic Re: Including Record # in one Document in QlikView

Including Record # in one Document

Fri, 12 Apr 2013 09:34:26 GMT

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

Re: Including Record # in one Document

alexandros17 — Fri, 12 Apr 2013 09:45:07 GMT

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

Re: Including Record # in one Document

Fri, 12 Apr 2013 10:45:02 GMT

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

Re: Including Record # in one Document

alexandros17 — Fri, 12 Apr 2013 11:43:23 GMT

Yes, it's true,

in the sort tab (properties of the chart) you have to sort by price in descendent order.

Re: Including Record # in one Document

Fri, 12 Apr 2013 12:18:48 GMT

I already tested, but when you have a rowno() column and uses the sort by price is not working

Re: Including Record # in one Document

alexandros17 — Fri, 12 Apr 2013 12:19:51 GMT

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

Re: Including Record # in one Document

Fri, 12 Apr 2013 12:27:29 GMT

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.

Re: Including Record # in one Document

Fri, 12 Apr 2013 12:28:38 GMT

Sorry,

But I don't understand whar do you mind.

Re: Including Record # in one Document

alexandros17 — Fri, 12 Apr 2013 12:36:18 GMT

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

Re: Including Record # in one Document

Fri, 12 Apr 2013 12:43:55 GMT

It's not working. I have as Dimension SKN, CATEGORY and I sorted by CATEGORY and after SUM(PRICE)

Re: Including Record # in one Document

kaushiknsolanki — Fri, 12 Apr 2013 13:12:03 GMT

Hi,

Try this.

Expression as Rowno(total)

Regards,

Kaushik Solanki

Re: Including Record # in one Document

Mon, 15 Apr 2013 07:38:26 GMT

Kaushik,

Is not working in this way. If I sorted the column (PRICE) and after I include as expression ROWNO(Total), the (PRICE) column change the order.

Re: Including Record # in one Document

Mon, 15 Apr 2013 14:14:59 GMT

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