topic Re: set analysis in QlikView

set analysis

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

hello

I have a excel file like bellow:

name telephone

aaa 2222222

bbb 8888888

bbb 9999999

aaa 2222222

i want to show the names with 2 different phone number like "bbb"

i would appreciate if anyone can help me in writing set analysis.

Re: set analysis

jagan — Mon, 14 Mar 2016 08:57:29 GMT

HI,

Try like this

Chart: STraight Table

Dimension: Name

Expression: If(Count(Distinct telephone) > 1, Concat(telephone, ',', 0)

Regards,

Jagan.

Re: set analysis

Kushal_Chawda — Mon, 14 Mar 2016 09:06:00 GMT

Create the straight table

Dimension : Name

Expression : Concat ({<Name={"=count(distinct telephone)>1"}>}Name,',')

Re: set analysis

martinien — Mon, 14 Mar 2016 09:23:39 GMT

Hi,

You can concat these simply in a text area with something like

=Concat(DISTINCT {<name={"=Count(telephone)>1"}>} name, ' - ' )

Also keep in mind than you can use the search string in listbox to find these kind of things quickly :

Martin

Re: set analysis

ramasaisaksoft — Mon, 14 Mar 2016 09:30:10 GMT

Hi Kabir,

PFA..

Re: set analysis

PradeepReddy — Mon, 14 Mar 2016 10:19:29 GMT

see the attachment...

Re: set analysis

Anonymous — Mon, 14 Mar 2016 10:22:08 GMT

Thank you jagan it worked

Re: set analysis

Anonymous — Mon, 14 Mar 2016 10:39:55 GMT

Jagan i missed one condition

we must not have different phone number in each month

fore example if a person have two different numbers in month Jan and Feb it's OK

How can i add month condition in expression?

Re: set analysis

Kushal_Chawda — Mon, 14 Mar 2016 10:57:13 GMT

I think you can use

If(aggr(Count(Distinct telephone),Month,Name) > 1, Concat(telephone, ',', 0)

Re: set analysis

Anonymous — Mon, 14 Mar 2016 11:35:09 GMT

Unfortunately it didn't work.

Re: set analysis

Kushal_Chawda — Mon, 14 Mar 2016 11:43:46 GMT

try this

If(aggr(Count(Distinct telephone),Name&Month) > 1, Concat(telephone, ',', 0)

Re: set analysis

jagan — Tue, 15 Mar 2016 00:45:21 GMT

Hi,

Adding Month dimension will solve this issue, did you tried it.

If you do not want to add then try below expression.

Chart: STraight Table

Dimension: Name

Expression: Concat(Aggr(If(Count(Distinct telephone) > 1, telephone), Name, Month), ',', 0)

Hope this helps you.

Regards,

Jagan.

Re: set analysis

Anonymous — Tue, 15 Mar 2016 07:49:26 GMT

it didn't work too, i add dimension thank you

Re: set analysis

Anonymous — Tue, 15 Mar 2016 07:50:22 GMT

The expression didn't work but i add dimension and it worked thank you so much