topic help with filter in QlikView

help with filter

beck_bakytbek — Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

i have the following situation:

my table does look like:

id	name	value	text
1	test1	10	aa
2	test2	20	aaa
3	test3	30	aaaa
4	test1	40	b
5	test2	50	bb
6	test3	60	bbb
7	test1	70	c
8	test2	80	cc
9	test3	90	ccc
10	test1	100	cccc

i tried to implement this expression : Only({<name = {"test1"}>}text), but it does not work

my expected output is field: text: aa, b,c,cccc

i know i can solve this issue in script by clausel where name = 'test1', but i want to know, whether is possible within a chart: pivot, straightable.

Thanks a lot for any and all help

Beck

Re: help with filter

surendraj — Fri, 21 Apr 2017 12:24:52 GMT

could you try with..

sum({<name = {"test1"}>}value)

Re: help with filter

Aurelien_Martinez — Fri, 21 Apr 2017 12:31:17 GMT

Hi,

Concat(Distinct {<name = {"test1"}>} text, ', ')

Re: help with filter

beck_bakytbek — Fri, 21 Apr 2017 12:33:34 GMT

Hi Surenda,

i tried, but it does not work, i want see only text with values: aa, b,c,cccc on the base of name = test1

do you have any idea?

Beck

Re: help with filter

CarlosAMonroy — Fri, 21 Apr 2017 12:33:55 GMT

or you can try:

If(name = 'test1',only(text))

Re: help with filter

beck_bakytbek — Fri, 21 Apr 2017 12:36:21 GMT

Hi Martines,

thanks for your feedback, but it does not work

Re: help with filter

beck_bakytbek — Fri, 21 Apr 2017 12:38:16 GMT

Hi Carlos, thanks a lot for your feedback

but the same, it does not work

Re: help with filter

Kushal_Chawda — Fri, 21 Apr 2017 12:40:33 GMT

this expression should work

Concat(Distinct {<name = {"test1"}>} text, ', ')

Please share the sample data and expected output need

Re: help with filter

CarlosAMonroy — Fri, 21 Apr 2017 12:42:31 GMT

Hi, it does work!

Please see image below: I used the data you posted on Inline table and use a straight table to show the results.

Re: help with filter

beck_bakytbek — Fri, 21 Apr 2017 12:47:55 GMT

Thanks a lot Carlos,

i misplaced a charakter , thanks a lot for your help

Re: help with filter

beck_bakytbek — Fri, 21 Apr 2017 12:48:13 GMT

Thanks a lot Kushal,

i misplaced a charakter

, thanks a lot for your help

Re: help with filter

beck_bakytbek — Fri, 21 Apr 2017 12:48:34 GMT

Thanks a lot Martinez for your help

Re: help with filter

beck_bakytbek — Fri, 21 Apr 2017 12:49:03 GMT

Thanks a lot Surenda for your help