Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
pra_kale
Creator III
Creator III

How to build Predictive data model..please help

Hi All,

I already build one data model in that around 30 to 40 lacs of records are available. In that I have number of predictors like channel, Product, Agent, Proofs submitted by customers, Age, etc. From this model I am getting number of customers are withdrawing the policy.

So I want the my model should tell me if the certain combination is get's repeated, then it should raise a alarm for me.

For e.g. From Total data size of 10000 and from that If Total 100 customers withdrawing the policies have the  Address Proof PAN card, Purchase product CUM, Agent Number is 0001, Branch code is 113, Age bucket is 30 To 40 years.

So I want out-put like below in one sheet...

  • TOP 10 combinations (on the basis of %) that constitute withdrawn policies.

   

Address ProofProductAgent NumberBranch codeAge Bucket%
PAN cardCUM123123430 To 40 Years30%
Driving licenseAUM234345650 To 60 Years20%

  • If any new policy received with that combinations then it should tell me the count in one Table.   
Address ProofProductAgent NumberBranch codeAge BucketTotal Policies Received
PAN cardCUM123123430 To 40 Years             1000
Driving licenseAUM234345650 To 60 Years              5000

If you provide any application for reference then it is vary useful.

Thanks in advance.

0 Replies