topic Re: Referencing another row in a table in QlikView

Referencing another row in a table

c_gilbert — Wed, 27 Nov 2013 14:47:51 GMT

Please can anyone help, we currently have a straight table with the 'Ward' as the dimension, and results and RAG ratings as the expressions.

For some results, the wards have joint data, but we don't want to duplicate the data at the source, we just want to base the RAG rating of one ward on another ward.

For example, here is a very simple representation of what we have now. At the moment Ward1b is showing red as there is no data, but we want it to show green, as Ward1a is green.

Ward	Result	RAG rating
Ward1a	90%	Green
Ward1b	-	Red

And this is what we want to get to:

Ward	Result	RAG rating
Ward1a	90%	Green
Ward1b	Joint Ward	Green

Any help would be much appreciated

Re: Referencing another row in a table

c_gilbert — Fri, 13 Dec 2013 10:49:19 GMT

No one?

Re: Referencing another row in a table

Fri, 13 Dec 2013 10:55:39 GMT

How do you make the link between Ward1a and 1b ?

Chris

Re: Referencing another row in a table

jvishnuram — Fri, 13 Dec 2013 10:56:02 GMT

Hi c_gilbert,

If possible can you share the qvw.

Re: Referencing another row in a table

tresB — Fri, 13 Dec 2013 10:56:22 GMT

Probably you can get it using peek()/previous() in the script, or above() in the chart. Please create a sample table (in excel or inline load) and explain the expected output with some 10-15 rows.

Re: Referencing another row in a table

c_gilbert — Fri, 13 Dec 2013 11:00:33 GMT

Sorry I can't share the qvw.

But basically, we have the different indicators as the expressions along the top, and the wards as the dimension down the side. For some indicators, there is data for both wards, but for others, they submit data jointly under one ward ID.

It's hard to explain but I appreciate any help. Thank you.

Re: Referencing another row in a table

c_gilbert — Fri, 13 Dec 2013 11:02:18 GMT

I'll try to create some dummy data in a qvw that I can share, thank you.

Re: Referencing another row in a table

c_gilbert — Fri, 13 Dec 2013 11:42:42 GMT

Hopefully this makes more sense.

In the last table, I have forced it to show what I want it to show, but we want a way of doing this automatically, so that whatever the performance is for the 'main' ward, it will show the same in the 'joint' ward for Indicator_2.

Re: Re: Referencing another row in a table

jvishnuram — Fri, 13 Dec 2013 11:54:07 GMT

Hi c_gilbert,

Refer the output or result table in the attached qvw.

Re: Referencing another row in a table

c_gilbert — Fri, 13 Dec 2013 12:16:29 GMT

Thanks but this doesn't work when the wards are re-ordered (in the full document there are around 100 wards, and users can sort by any indicator or ward.

Re: Re: Referencing another row in a table

jvishnuram — Fri, 13 Dec 2013 12:32:50 GMT

Then you need to code the same in the script itself.

Re: Referencing another row in a table

c_gilbert — Fri, 13 Dec 2013 12:45:20 GMT

How? in the real document the data is coming from SQL tables which are updated each day.

Re: Referencing another row in a table

Fri, 13 Dec 2013 13:05:16 GMT

I reckon you can't do much unless your data are strictly ordered or Ward IDs are linked together

regards

Chris

Re: Re: Referencing another row in a table

Fri, 13 Dec 2013 13:06:07 GMT

Hey

can you please check the attachment.

Thanks

Angad

Re: Referencing another row in a table

c_gilbert — Fri, 13 Dec 2013 13:12:53 GMT

Same as previous reply - doesnt work when re-ordered.

Re: Referencing another row in a table

Fri, 13 Dec 2013 13:22:05 GMT

Then you have to use the same logic in script itself. using peek/previous functions. since we are using above() function which is chart level, and any change in sorting would effect it.

Re: Referencing another row in a table

c_gilbert — Fri, 13 Dec 2013 14:28:31 GMT

I'm not sure how this would work, as all our data is at record level, and is loaded from qvd files.