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: 
paulyeo11
Master
Master

=IF(GROUP_CLASS='G1',COMPANY) it is cause by data model issue ?


Hi All


I using below expression at dimension at table it does not filter G1 company  :-


=IF(GROUP_CLASS='G1',COMPANY)


it work for QV V12 , but does not work for QV9 and QS later version.


May i know it is due to my data model issue ?


Paul Yeo

15 Replies
paulyeo11
Master
Master
Author

Hi Kris

Thank you very much .

One more last question , this particular field that having problem , I have using partial reload . Do you think that is partial reload approach is one of the reasons cause the problem ?

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

krishna_2644
Specialist III
Specialist III

Partial reload is a different feature where if you want to reload only few tables(usually to update only few tables) from a large number of tables  in your data model.

We use 'Add' or 'replace' right above the 'load' in script of that table and do the partial reload.if dont use 'Add' or 'replace' before the table,then it isnt called a partial reload.Please check partial reload from QLik documentation for more details.

Thanks

paulyeo11
Master
Master
Author

Hi Kri

My understand of partial reload is below , do you think this will create problem ?

sales_G:


LOAD GROUP_CLASS,SOURCE,


//if(Exists(COMPANY),0,1) as NewFlag,


    if (GROUP_CLASS='G1' and SOURCE='TDSS','G1',

    if (GROUP_CLASS='G2' and SOURCE='TDSS','G2',

    if (GROUP_CLASS='G3' and SOURCE='TDSS','G3',

    if (GROUP_CLASS='G4' and SOURCE='TDSS','G4',

if (GROUP_CLASS='G5' and SOURCE='TDSS','G5',


    if (GROUP_CLASS='G6' and SOURCE='TDSS','G6',

    if (GROUP_CLASS='G7' and SOURCE='TDSS','G7',

    if (GROUP_CLASS='G8' and SOURCE='TDSS','G8',

    if (GROUP_CLASS='G9' and SOURCE='TDSS','G9',

   

    if (GROUP_CLASS='G12' and SOURCE='TDSS','G12',

    if (GROUP_CLASS='G13' and SOURCE='TDSS','G13',

    if (GROUP_CLASS='G1' and SOURCE='TDSKL','G1', 

    if (GROUP_CLASS='G2' and SOURCE='TDSKL','G1', 

    if (GROUP_CLASS='G1' and SOURCE='TDST','G1', 

    if (GROUP_CLASS='G2' and SOURCE='TDST','G2', 

    if (GROUP_CLASS='G3' and SOURCE='TDST','G3', 

    if (GROUP_CLASS='G4' and SOURCE='TDST','G4', 

    if (GROUP_CLASS='G1' and SOURCE='TDSPG','G1',

    if (GROUP_CLASS='G1' and SOURCE='ADL','G1', 

    ))))))))))))))))))) as [GROUPCLASS],

   

    if (GROUP_CLASS='G1' and SOURCE='TDSS','G1-GT',

    if (GROUP_CLASS='G2' and SOURCE='TDSS','G2-AP',

    if (GROUP_CLASS='G3' and SOURCE='TDSS','G3-SL',

    if (GROUP_CLASS='G4' and SOURCE='TDSS','G4-CL',

    if (GROUP_CLASS='G5' and SOURCE='TDSS','G5-RW',

    if (GROUP_CLASS='G6' and SOURCE='TDSS','G6-PG',

    if (GROUP_CLASS='G7' and SOURCE='TDSS','G7-BP',

    if (GROUP_CLASS='G8' and SOURCE='TDSS','G8-KL',

    if (GROUP_CLASS='G9' and SOURCE='TDSS','G9-TH',

    if (GROUP_CLASS='G12' and SOURCE='TDSS','G12-EX',

    if (GROUP_CLASS='G13' and SOURCE='TDSS','G13-ID',

   

    if (GROUP_CLASS='G1' and SOURCE='TDSKL','G1-ZA', 

    if (GROUP_CLASS='G2' and SOURCE='TDSKL','G1-MS', 

    if (GROUP_CLASS='G1' and SOURCE='TDST','G1', 

    if (GROUP_CLASS='G2' and SOURCE='TDST','G2', 

    if (GROUP_CLASS='G3' and SOURCE='TDST','G3', 

    if (GROUP_CLASS='G4' and SOURCE='TDST','G4', 

    if (GROUP_CLASS='G5' and SOURCE='TDST','G5', 

    if (GROUP_CLASS='G1' and SOURCE='TDSPG','G1-DC',

    if (GROUP_CLASS='G1' and SOURCE='ADL','G1',       

    )))))))))))))))))))) as [GROUP_CLASS_O],


    if (GROUP_CLASS='G1' and SOURCE='TDSS','G1-GT',

    if (GROUP_CLASS='G2' and SOURCE='TDSS','G2-AP',

    if (GROUP_CLASS='G3' and SOURCE='TDSS','G3-SL',

    if (GROUP_CLASS='G4' and SOURCE='TDSS','G4-CL',

    if (GROUP_CLASS='4' and SOURCE='TDSS','G4-CL',

    if (GROUP_CLASS='G5' and SOURCE='TDSS','G5-RW',

    if (GROUP_CLASS='G6' and SOURCE='TDSS','G6-PG',

    if (GROUP_CLASS='G7' and SOURCE='TDSS','G7-BP',

    if (GROUP_CLASS='G8' and SOURCE='TDSS','G8-KL',

    if (GROUP_CLASS='G9' and SOURCE='TDSS','G9-TH',

    if (GROUP_CLASS='G11' and SOURCE='TDSS','G11-AO',   

    if (GROUP_CLASS='G12' and SOURCE='TDSS','G12-EX',

    if (GROUP_CLASS='G13' and SOURCE='TDSS','G13-ID',

    if (GROUP_CLASS='G1' and SOURCE='TDSKL','G1', 

    if (GROUP_CLASS='G2' and SOURCE='TDSKL','G1', 

    if (GROUP_CLASS='G1' and SOURCE='TDST','G1', 

    if (GROUP_CLASS='G2' and SOURCE='TDST','G2', 

    if (GROUP_CLASS='G3' and SOURCE='TDST','G3', 

    if (GROUP_CLASS='G4' and SOURCE='TDST','G4', 

    if (GROUP_CLASS='G5' and SOURCE='TDST','G5', 

    if (GROUP_CLASS='G1/1' and SOURCE='TDST','G1/1', 

    if (GROUP_CLASS='G1/2' and SOURCE='TDST','G1/2', 

    if (GROUP_CLASS='G2/1' and SOURCE='TDST','G2/1', 

    if (GROUP_CLASS='G2/2' and SOURCE='TDST','G2/2', 

    if (GROUP_CLASS='G3/1' and SOURCE='TDST','G3/1', 

    if (GROUP_CLASS='G3/2' and SOURCE='TDST','G3/2', 

    if (GROUP_CLASS='G1' and SOURCE='TDSPG','G1',

    if (GROUP_CLASS='G99' and SOURCE='TDSS','3Yr Stop',

    if (GROUP_CLASS='G1' and SOURCE='ADL','G1',       

    if (GROUP_CLASS='G1' and SOURCE='TDSID','G1',       

    if (GROUP_CLASS='G2' and SOURCE='TDSID','G2',       

   

    ))))))))))))))))))))))))))))))) as [GROUP_CLASS_]

   

//    if (GROUP_CLASS='G1' and SOURCE='TDST','G1', 

//    if (GROUP_CLASS='G2' and SOURCE='TDST','G2', 

//    if (GROUP_CLASS='G3' and SOURCE='TDST','G3', 

//    if (GROUP_CLASS='G4' and SOURCE='TDST','G4', 

//if (GROUP_CLASS='G5' and SOURCE='TDSS','G4-CL',

  

resident sales;

krishna_2644
Specialist III
Specialist III

Partial Reload is used whenever you just want to add some new data without reloading all other tables.

Suppose in your Qlikview file you have 10 tables which has millions of records, if you want one new table then you need to add the script, if you give normal reload it will reload all the 10 tables along with the new table.  Suppose if you don't want to reload the old 10 tables and just want to reload just the new table then Partial Reload would be helpful.

This can done by using the ADD attribute to LOAD statement.

sales_G:

ADD

LOAD

GROUP_CLASS,SOURCE,

..

...

.....

resident sales;


Now if you use Partial reload, it just reloads the 'sales_G' and not any other table.

Partial reload ,Just like you hit reload button,you can do 'Partial reload' from


1.PNG


Hope this helps you.

paulyeo11
Master
Master
Author

Now I understand what is partial reload mean. Thank you.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

paulyeo11
Master
Master
Author

Hi Kris

So partial reload should not create issue , so i need to focus on 2 table only one field is linked.

Thank you very much for your sharing.

Paul Yeo