topic contains in expression in QlikView

contains in expression

rafael5958 — Tue, 10 Sep 2019 14:56:26 GMT

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.

Re: contains in expression

jmartineze — Tue, 10 Sep 2019 07:25:11 GMT

Hello, maybe you can use a text object.

Re: contains in expression

rafael5958 — Tue, 10 Sep 2019 15:00:50 GMT

Tried to modify my example so it could be more clear. Still dont know how to do it.

Re: contains in expression

Brett_Bleess — Thu, 19 Sep 2019 20:59:10 GMT

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

Re: contains in expression

Saravanan_Desingh — Sun, 24 May 2020 16:51:06 GMT

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.