topic Re: match, record in QlikView

match, record

shahamel — Tue, 05 Mar 2013 09:40:59 GMT

Dear QV-users,

I have a small problem,

i am searching for an expression that uses data from a record that matches a keyitem within that record,

Example

CITO-ID	% gewichtenleerlingen	ondergre	landelijk gemiddelde	bovengrens
1	0	535,2	537,2	539,2
2	1	535,1	537,1	539,1
3	2	534,9	536,9	538,9
4	3	534,8	536,8	538,8
5	4	534,6	536,6	538,6
6	5	534,5	536,5	538,5
7	6	534,3	536,3	538,3
8	7	534,2	536,2	538,2

If my expression calculate 6 as '%gewichtenleerlingen',

it should automaticly use 'landelijk gemiddelde' 536,6,

how do i do that?

Thanx in advance

Re: match, record

manideep78 — Tue, 05 Mar 2013 09:46:55 GMT

I am not sure I understood your requirement.

If your expression calculate 6 as '%gewichtenleerlingen',

how can you use 'landelijk gemiddelde' 536,6, instead 536,3????

Could you please explain your requirement in detail.

Re: match, record

sushil353 — Tue, 05 Mar 2013 09:54:34 GMT

hi,

I am not getting, how u are getting data in "landelijk gemiddelde" the value "537,2" is concatenation of 537 and 2 or something else.

Still i have created a sample app for this. please find atttached.

HTH

sushil

Re: match, record

shahamel — Tue, 05 Mar 2013 10:00:09 GMT

you are right,

it should be 536,3 i made an error

Re: match, record

shahamel — Tue, 05 Mar 2013 10:07:14 GMT

the point is:

i have a table with standards (like "landelijk gemiddelde"), but this standard changes with the percentage ("%gewichtenleerlingen".

I can calculate the result

for example

the result is 536,3, the standard is 536,3, but only when '%gewichtenleerlingen' = 6, when this happens the result is beneath the standard. i would like to highlight the result with the color yellow, If '%gewichtenleerlingen' = 7, it should color gree, because the standard is 536,2.

I would like to see something like this:

Expression: calculate result

Text color; it calculates '%gewichtleerlingen' --> if it gives 6 as result it should use the standard 536,3.

I think it can be solved with the concat-function, but i don't know how

Re: match, record

shahamel — Tue, 05 Mar 2013 10:07:27 GMT

the point is:

i have a table with standards (like "landelijk gemiddelde"), but this standard changes with the percentage ("%gewichtenleerlingen".

I can calculate the result

for example

I would like to see something like this:

Expression: calculate result

Text color; it calculates '%gewichtleerlingen' --> if it gives 6 as result it should use the standard 536,3.

I think it can be solved with the concat-function, but i don't know how

Re: match, record

shahamel — Tue, 05 Mar 2013 10:28:43 GMT

Dear users,

this is something what i ment, but it should be colored , without seleting an CITO ID. Any suggestions?

Re: match, record

shahamel — Tue, 05 Mar 2013 10:44:45 GMT

THis should do the trigger