Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
shahamel
Contributor

match, record

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% gewichtenleerlingenondergrelandelijk gemiddeldebovengrens
10535,2537,2539,2
21535,1537,1539,1
32534,9536,9538,9
43534,8536,8538,8
54534,6536,6538,6
65534,5536,5538,5
76534,3536,3538,3
87534,2536,2538,2
If my expression calculate 6 as '%gewichtenleerlingen',
it should automaticly use 'landelijk gemiddelde' 536,6,
how do i do that?
Thanx in advance
Tags (3)
1 Solution

Accepted Solutions
shahamel
Contributor

Re: match, record

THis should do the trigger

View solution in original post

7 Replies
Partner
Partner

Re: match, record

Hi

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.

sushil353
Honored Contributor II

Re: match, record

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

shahamel
Contributor

Re: match, record

you are right,

it should be 536,3 i made an error

shahamel
Contributor

Re: match, record

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

shahamel
Contributor

Re: match, record

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

shahamel
Contributor

Re: match, record

Dear users,

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

shahamel
Contributor

Re: match, record

THis should do the trigger

View solution in original post