topic Re: How to Find Repeated Values or Characters in Pivot Table in QlikView

How to Find Repeated Values or Characters in Pivot Table

khasimvali85 — Tue, 30 Sep 2014 04:32:48 GMT

Hi Community,

Can you give the formule for how to find Repeated value in Pivot Table

I Have the data given below

CallNO CallCount RepeatedNo

------------------------------------------- --------------------------------------- ----------------------------

hyd1234,hyd1234,hyd1234,hyd3456, 3,1 hyd1234

del1234,del8763,del8763,del8763,del8763 1,4 del8763

Can anybody give the formule for this?

Regards,

Khasim

Re: How to Find Repeated Values or Characters in Pivot Table

tresB — Tue, 30 Sep 2014 04:55:56 GMT

Use SubField() while loading to separate out the sub strings, like in attached sample.

Re: How to Find Repeated Values or Characters in Pivot Table

khasimvali85 — Tue, 30 Sep 2014 06:05:42 GMT

Hi tresesco,

Thanks for your replay I checked for your formule but it's not working i added one sample application.

Regards

Khasim.

Re: How to Find Repeated Values or Characters in Pivot Table

sushil353 — Tue, 30 Sep 2014 06:18:37 GMT

Hi,

if the below code help you..

for i=1 to 4

temp:

LOAD ID,

Value,

SubField(Value,',',$(i)) as test

FROM

t2.txt

(txt, utf8, embedded labels, delimiter is ',', msq);

NEXT i

t2 file is attached.

Re: How to Find Repeated Values or Characters in Pivot Table

tresB — Tue, 30 Sep 2014 06:20:25 GMT

Try:

Concat(If(AGGR(SUM({<ReminderDate= >}ReminderCall),RemComplaintNo)>=3,RemComplaintNo), ';')

Re: How to Find Repeated Values or Characters in Pivot Table

khasimvali85 — Tue, 30 Sep 2014 06:28:12 GMT

Hi Tresesco,

Tresesco Its working fine now Thanks for giving help.

Regards,

Khasim.

Re: How to Find Repeated Values or Characters in Pivot Table

khasimvali85 — Tue, 30 Sep 2014 07:04:38 GMT

Hi Tresesco,

I need One more formule for the same application, i wanna display in ReminderCall field >3Calls Should be shown in Red Colour.

Regards

Khasim.

Re: How to Find Repeated Values or Characters in Pivot Table

tresB — Tue, 30 Sep 2014 07:21:28 GMT

Re: How to Find Repeated Values or Characters in Pivot Table

khasimvali85 — Tue, 30 Sep 2014 07:30:27 GMT

Hi Tresesco,

Thanks for Suggesting but this is not my exact output, i wanna display >3 ReminderCall fields should be shown in Red Colour.

Example:

>3 ReminderCall

----------------------

1;1;1;1;1;1;12;2;2;2;3;3;3;4;4;4

above example i show only 3;3;3;4;4;4 should be in red Colour.

Regards,

Khasim.

Re: How to Find Repeated Values or Characters in Pivot Table

tresB — Tue, 30 Sep 2014 07:32:09 GMT

Unfortunately, color here works for entire cell, not for a part of cell.

Re: How to Find Repeated Values or Characters in Pivot Table

khasimvali85 — Tue, 30 Sep 2014 08:14:33 GMT

Hi Tresesco,

There is no other option to show pertecular value shown in colour?

Regards,

Khasim.