Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

searching for same dimension being repeated from one year to the other

Hi Every body

What script adjustment I need to do if I am to find out which pol policy numbers are repeated from 2017 to 2018. I look forward a very elaborated answer on this with working. (Kindly let me have the answer on the reply itself since I am on the Personnel licence).

Thank you very much in advance

Neville

1 Solution

Accepted Solutions
rubenmarin

Hi Neville, I don't understand, that code only flags with '1' policy numbers from 2018 that where loaded in 2017.

View solution in original post

5 Replies
nevilledhamsiri
Specialist
Specialist
Author

Please help me on this.

Thanks

rubenmarin

Hi neville, can you try?

2017:

LOAD BRANCH_CODE, CLASS_CODE, PRODUCT_CODE, POL_POLICY_NO, NAME, REF_NO, FROM_DATE, END_DATE, POL_SUM_INSURED, TR_DATE, TR_TYPE, CP, RS, TC, TOTAL, MARKETING_PERSON

FROM (ooxml, embedded labels, table is Sheet2)

2018:

LOAD BRANCH_CODE, CLASS_CODE, PRODUCT_CODE, POL_POLICY_NO, NAME, REF_NO, FROM_DATE, END_DATE, POL_SUM_INSURED, TR_DATE, TR_TYPE, CP, RS, TC, TOTAL, MARKETING_PERSON, Q, R, S, T,

If(Exists(POL_POLICY_NO), 1, 0) as isRepeated // Flag for repeated policy numbers

FROM (ooxml, embedded labels, table is Sheet3)

nevilledhamsiri
Specialist
Specialist
Author

Hi Ruben, Thanks for your reply. Sorry for the delay in responding as I was away.I need to verify with you as to what it carries other than 1 & 0. Because other than 1 & 0, there are  just bank rows with data.To what type they are fallen in to?. Total records value equal to Rs 17,294,133 whereas 1 equal to Rs 3,054,895 & 0 equal to Rs 3,327,820

rubenmarin

Hi Neville, I don't understand, that code only flags with '1' policy numbers from 2018 that where loaded in 2017.

nevilledhamsiri
Specialist
Specialist
Author

Thanks Ruben. The logic you propose is right

Neville