This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I am having two tables Customers and Relations.
Association between these two tables is IP_ID_Num.
When we select 200 from IP_ID_NUM, I get to see 400 from PRSL.
But my requirement is when we select a value from IP_ID_NUM, I need to search for that value in both IP_ID_NUM and PRSL fields.
When I select 200 from IP_ID_NUM, I need to see two rows.
1. IP_ID_NUM - 100 and PRSL - 200. (Because PRSL value is 200)
2. P_ID_NUM - 200 and PRSL - 400. (IP_ID_Num value is 200).
Can anyone please help me?
Thanks in advance!
(ooxml, embedded labels, table is Customers);
RowNo() as RelID, //Created ID field
(ooxml, embedded labels, table is Relation);
View solution in original post
As you mentioned -
I feel it should select
3. P_ID_NUM - 300 and PRSL - 200. (Because PRSL value is 200).
See if this can help. I needed ID field in Relation table -
Sorry, it should select 3 values. I need to see all the values of IP_ID_NUM where IP_ID_NUM or PRSL is 200.
2. IP_ID_NUM - 200 and PRSL - 400. (IP_ID_Num value is 200).
3. IP_ID_NUM - 300 and PRSL - 200. (Because PRSL value is 200).
Is there a way to achieve?
Did you try to attach any solution ?
Ya, I can see it attached? Are you not able to see QVW attached?
No I cannot. Can you please attach again?
Attaching qvw once again.
Now? I needed one extra ID field in relation table as Customer Id is repeating in relation table.
I don't see it. Can you please explain me how you did it?