About Data Modelling

sarfaraz_sheikh — Mon, 11 May 2015 13:05:09 GMT

Dear All,

i am using below code ......But did not getting expected output..I want Sarv Suraksha AS product_class2 for product_code 2950 marked in red colour below .......But i am getting reatil health as product_class2 for 2950 product.....Kindly suggest me how i can go with this..

if(wildmatch([Channel Partner-Channel Partner Name],'*HDFC BANK CC HEALTH*') and wildmatch([Product Details-Product Code],'HSP'),'Retail Health',

if(wildmatch([Product Details-Product Code],'HSP') and len([Channel Partner-Channel Partner Name])=0 or not(wildmatch([Channel Partner-Channel Partner Name],'*HDFC BANK CC HEALTH*')),'Retail Health',

if(wildmatch([Product Details-Product Code],2825) and wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',

'*BB000011HDFC BANK LTD (CLASSIC ON PHONE)*','*BB000010HDFC BANK LTD (PHONE BANKING)*'),'Retail Health',

if(wildmatch([Product Details-Product Code],2825) and len([Channel Partner-Channel Partner Name])=0 or not(wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',

'*BB000011HDFC BANK LTD (CLASSIC ON PHONE)*','*BB000010HDFC BANK LTD (PHONE BANKING)*')),'Retail Health',

if(wildmatch([Product Details-Product Code],2950) and wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',

'*BB000011HDFC BANK LTD (CLASSIC ON PHONE)*','*BB000010HDFC BANK LTD (PHONE BANKING)*'),'Sarv Suraksha',

if(wildmatch([Product Details-Product Code],2950) and not(wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',

'*BB000011HDFC BANK LTD (CLASSIC ON PHONE)*','*BB000010HDFC BANK LTD (PHONE BANKING)*')) or len([Channel Partner-Channel Partner Name])=0,'Sarv Suraksha',

if(wildmatch([Product Details-Product Code],'HSTOP') AND wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',

'*HDFC BANK CC HEALTH*'),'Retail Health',

if(wildmatch([Product Details-Product Code],'HSTOP') and not(wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',

'*HDFC BANK CC HEALTH*')) or len([Channel Partner-Channel Partner Name])=0,'Retail Health',

if(wildmatch([Product Details-Product Code],2849) AND wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',

'*HDFC BANK CC HEALTH*'),'Retail Health',

if(wildmatch([Product Details-Product Code],2849) and not(wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',

'*HDFC BANK CC HEALTH*')) or len([Channel Partner-Channel Partner Name])=0,'Retail Health',

if(wildmatch([Product Details-Product Code],2850) AND wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',

'*HDFC BANK CC HEALTH*'),'Retail Health',

if(wildmatch([Product Details-Product Code],2850) and not(wildmatch([Channel Partner-Channel Partner Name],'*BB000004HDFC BANK LTD (CREDIT CARD DIVISION)*',

'*HDFC BANK CC HEALTH*')) or len([Channel Partner-Channel Partner Name])=0,'Retail Health')))))))))))) AS Product_Class2

Sarfaraz

Re: About Data Modelling

sujeetsingh — Mon, 11 May 2015 13:12:44 GMT

Follow this

Best Practices for Data Modelling

topic About Data Modelling in QlikView

About Data Modelling

Re: About Data Modelling