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: 
prahlad_infy
Partner - Creator II
Partner - Creator II

Keys are not working to get desired result . Please help .

Hello Sirs ,

Keys are not working to get desired result . Please help .

Transction_Table1:

LOAD * INLINE [

   

    Pep1, Pep_ID, Con1, Con_ID, Book_ID, Type_Name, Type_id, YEAR, AREA

    Ramgy1, R001, Rony, R1, AB1, Chelasa X, CX1, 2018, Sales

    Ramgy1, R001, JIBO, R2, AB1, Chelasa X, CX1, 2018, Bank

    Ramgy1, R001, tena, R3, AB3, Chelasa X, CX1, 2018, Craf

    Ramgy1, R001, Bilo, R4, AB4, BOSO Y, BO1, 2018,

    Ramgy1, R001, HUSSY, R5, AB5, BOSO Y, BO1, 2018,

    Ramgy2, R002, Rony, R1, AB6, BOSO Y, BO1, 2018, HF

    Ramgy2, R002, JIBO, R2, AB7, BRCK, BR01, 2018, Credit

    Ramgy2, R002, tena, R3, AB8, BRCK, BR01, 2018, Bonds

    Ramgy9, R009, Azura, R01, AB99, BRCK, BR01, 2018, Bonds

];

Transction_Table:

LOAD * ,

Pep_ID &' | '& Con_ID &' | '& Type_id  as Key1

Resident Transction_Table1 ;

DROP Table Transction_Table1 ;

Ref_TABLE1:

LOAD * INLINE [

  

    Pep1_Set, Pep1_ID, Con_SET, Con_ID_SET, Type_Name_SET, Type_id_SET, Set_v_SET

    Ramgy1, R001, Rony, R1, Chelasa X, CX1, 0.688637994

    Ramgy1, R001, JIBO, R2, Chelasa X, CX1, 0.416381848

    Ramgy1, R001, tena, R3, Chelasa X, CX1, 0.848939441

    Ramgy1, R001, Bilo, R4, BOSO Y, BO1, 0.164606907

    Ramgy1, R001, HUSSY, R5, BOSO Y, BO1, 0.925790609

    Ramgy2, R002, Rony, R1, BOSO Y, BO1, 0.249511708

    Ramgy2, R002, JIBO, R2, BRCK, BR01, 0.275181944

    Ramgy2, R002, tena, R3, BRCK, BR01, 0.027021723

    Ramgy3, R003, JOE, J01, Hathway, HWYX01, 0.426505072

    Ramgy3, R003, JHON, JH01, Hathway, HWYX01, 0.516350849

    Ramgy3, R003, TRACY, TRC01, Hathway, HWYX01, 0.486502392

    Ramgy6, R006, AMIGO, AMOG01, BRCK, BR01, 0.860334923

];

Ref_TABLE:

LOAD * ,

'Covered' as Policy ,

Pep1_ID &' | '& Con_ID_SET &' | '& Type_id_SET as Key1

Resident Ref_TABLE1 ;

DROP Table Ref_TABLE1 ;

Exp-output

1)

Keys.png

2) Filter with Values Set and Not Set

Thank You Gurus .

1 Solution

Accepted Solutions
rajivmeher
Creator
Creator

Hi prahlad.infy

Please see the attached and suggest if this helps?

Regards

Rajiv.

View solution in original post

6 Replies
rajivmeher
Creator
Creator

Hi prahlad.infy

Please see the attached and suggest if this helps?

Regards

Rajiv.

prahlad_infy
Partner - Creator II
Partner - Creator II
Author

Is there any other way ?

However i needed filter/listbox having values  covered and not covered

prahlad_infy
Partner - Creator II
Partner - Creator II
Author

We have three scenario          

1) Record only present in Transction_Table should have a Policy field with value as   'Not covered ' .

2) Record only present in Ref_TABLE should have a Policy field with value as   'Covered ' .


3) Record present in both table should have a Policy field with value as   'Covered ' .


How to achieve this in script ? tresesco‌ . Please help .. I do not want to do any changes using calculated dimension (example which was shared by Rajiv )


Thank You in the advance .

rajivmeher
Creator
Creator

Hi Prahlad

Thanks for your feedback. Will it serve your purpose if its done in the load script?

You can put conditional statement on your load of Ref_TABLE as when Transction_Table Pep_ID is NULL then 'Not covered' else 'covered'.

This way you wont have to do any change on dimension level anymore, as the data will come directly from the table.

Regards

Rajiv.

prahlad_infy
Partner - Creator II
Partner - Creator II
Author

Thanks you Sir , But i did not undertsand how above will help . Can you please share qvw with your solution ?

rajivmeher
Creator
Creator

Hi prahlad.infy

Please see if the attached would help?

Regards

Rajiv.