Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have:
case:
LOAD * INLINE [
case
400,
300
];
A:
LOAD * INLINE [
id1, name1, id2, name2, case
1, Tom,2, Jim, 400,
1, Tom,3, Paul, 400
2, Jim,3, Paul, 400
1, Tom,2, Jim, 300
4, Mary,4, Mark, 400
5, Mary,6, Jane, 300
];
I need an expression to show in a dimension table only the result when I select case 400.
id1 | name1 | id2 | name2 | count(1) | //if((id1=id2),id2,'') if(match(id1,id2),id2,'') |
1 | Tom | 2 | Jim | 1 |
something like if id2 ( contains id1) maybe, but dont know how to do it.
Rafael, about the best I can do for you is point you to the Design Blog area where you can search for posts there that might help, I would have looked for you, but I am not exactly sure what you are trying to do here.
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
If you have not searched the QlikView Forum for prior posts, that is the other thing I would recommend as well, as there may be one or two out there with suggestions etc. This will kick the post back up, so someone else may chime in as well, but I wanted to give something to try to move it forward.
Regards,
Brett
Hello, maybe you can use a text object.
Tried to modify my example so it could be more clear. Still dont know how to do it.
Rafael, about the best I can do for you is point you to the Design Blog area where you can search for posts there that might help, I would have looked for you, but I am not exactly sure what you are trying to do here.
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
If you have not searched the QlikView Forum for prior posts, that is the other thing I would recommend as well, as there may be one or two out there with suggestions etc. This will kick the post back up, so someone else may chime in as well, but I wanted to give something to try to move it forward.
Regards,
Brett
Can you please explain more on your requirement? Do you want to show the first row of 400, when you select 400? Sorry I can't understand your requirement clearly.