Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
khasimvali85
Creator II
Creator II

How to Find Repeated Values or Characters in Pivot Table

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try:

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

View solution in original post

10 Replies
tresesco
MVP
MVP

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

khasimvali85
Creator II
Creator II
Author

Hi tresesco,

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

Regards

Khasim.

sushil353
Master II
Master II

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.

tresesco
MVP
MVP

Try:

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

View solution in original post

khasimvali85
Creator II
Creator II
Author

Hi Tresesco,

              

                   Tresesco Its working fine now Thanks for giving help.

Regards,

Khasim.

khasimvali85
Creator II
Creator II
Author

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.

tresesco
MVP
MVP

Screen Shot 09-30-14 at 12.51 PM.PNG.png

khasimvali85
Creator II
Creator II
Author

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.

tresesco
MVP
MVP

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