topic Re: variable selection and score model business logic build on the fly in QlikView

variable selection and score model business logic build on the fly

Thu, 27 Jul 2017 06:18:13 GMT

Team,

I need your help to check qlikview technical feasibility for below requirements.

data feed Fields: Claim#,cat1_var1,cat1_var2,cat1_var3,cat1_var4,cat2_var1,cat2_var2,cat2_var3,cat2_var4,cat3_var1,cat3_var2,

cat3_var3,cat3_var4

step1: Qlikview UI to list down cat1 / cat2 / cat3 measure fields and user should be able to multi select these measure fields

step 2: Store selected measure fields to variable

step3: Use selected measure fields to perform mathematical operations to calculate score.

Need solution to this at the earliest. To be precise I wanted to achieve attached excel scoring model in Qlikview.

Thanks,

Keerthy

Re: variable selection and score model business logic build on the fly

vikasmahajan — Thu, 27 Jul 2017 06:37:30 GMT

Hi ,

You can try ad-hoc reporting for your requirement , check this with this demo https://www.analyticsvidhya.com/blog/2014/01/customize-reporting-qlikview/

Vikas

Re: variable selection and score model business logic build on the fly

Thu, 27 Jul 2017 09:21:43 GMT

Hi Vikas,

Thanks for the swift response. I have attached my detailed requirement in the excel file. Request you to review and suggest solution.

Thanks in advance,

Keerthy

Re: variable selection and score model business logic build on the fly

Kushal_Chawda — Thu, 27 Jul 2017 10:21:43 GMT

What is the Actual data format? Is this format fix or it will get changed?

Re: variable selection and score model business logic build on the fly

Thu, 27 Jul 2017 10:29:50 GMT

Kushal,

Thanks for your question. Number of variables and derived field formula remains same but user should have a flexibility to select variable for model inclusion / exclusion.

I presume this answers your questions.

Thanks,

Keerthy