topic Re: Calculated dimension problem in QlikView

Calculated dimension problem

sarfaraz_sheikh — Fri, 13 Mar 2015 07:23:49 GMT

Dear ALL,

I have one column called as ' STATUS_ID' having following contents....

(75,77,78,80,82,87,91,93,94,100)

I am taking this in calculated dimension.like below

if(Wildmatch(STATUS_ID,80),'Insurer_Reject',if(Wildmatch(STATUS_ID,75),'Follow_Up' , if(Wildmatch(STATUS_ID,75,80),'Sales_Closed_Final')))

I am getting Insurer Reject and Follow_up as dimension content however i am not getting sales_closed_final in dimension content

What can be the reason ? ..........Is something i am doing wrong.....If it is possible then how i can do this

Kindly help

Sarfaraz

Re: Calculated dimension problem

amit_saini — Fri, 13 Mar 2015 07:29:38 GMT

Hi,

This might help u:

How to rename my Pie-Chart Values?

Thanks,
AS

Re: Calculated dimension problem

jonathandienst — Fri, 13 Mar 2015 08:10:52 GMT

Because Sales_Closed_Final uses the same values of STATUS_ID in your expression as the other two (75,80).

This can be more efficiently written:

Pick(Match(STATUS_ID, 80, 75, xx), 'Insurer_Reject', 'Follow_Up' , 'Sales_Closed_Final')

(replace xx with the correct code for Sales_Closed_Final)

HTH

Jonathan

Re: Calculated dimension problem

Fri, 13 Mar 2015 08:29:42 GMT

Final'

=if(Wildmatch(STATUS_ID,80),'Insurer_Reject',if(Wildmatch(STATUS_ID,75),'Follow_Up' , 'Sales_Closed_Final'))

this might helps you if any comes expect 80,75 remaing things will for 'Sales_Closed_Final' category

Please find my attachment

Re: Calculated dimension problem

Fri, 13 Mar 2015 08:37:14 GMT

This also give appropriate result

=if(Wildmatch(STATUS_ID,80),'Insurer_Reject',if(Wildmatch(STATUS_ID,75),'Follow_Up' ,if(STATUS_ID>75 and STATUS_ID<80, 'Sales_Closed_Final')))

Re: Calculated dimension problem

sarfaraz_sheikh — Fri, 13 Mar 2015 08:42:31 GMT

Dear jonathan,

there is no any specific code for Sales_closed_final. It is calculating by the combination of Insurer Reject and Follow_up code i.e 80 and 75 respectively.

Sales_closed_final=80+75 likewise

Is it possible ...if yes then how i can do this .......Please reply !!!!!!

Sarfaraz

Re: Calculated dimension problem

sarfaraz_sheikh — Fri, 13 Mar 2015 09:16:38 GMT

Kindly reply its urgent !!!!!!!!!!

Sarfaraz

Re: Calculated dimension problem

jonathandienst — Fri, 13 Mar 2015 09:23:23 GMT

Sounds like a hierarchy:

Status - 75/80 'Closed'

Reason - 75 'Insurer_Reject', 80 'Follow_Up'

...

If(Match(Status, '75', '80'), 'Closed', 'Open) As Status1,

PIck(Match(Status, 75, 80), 'Insurer_Reject', 'Follow_Up') As Reason,

...

HTH

Jonathan

Re: Calculated dimension problem

sarfaraz_sheikh — Fri, 13 Mar 2015 09:29:35 GMT

Dear Jonathan,

75 - Insurer reject containas value 20

80 - Follow_up contains value 30

75,80 - Sales_closed_date will contains the value 50 ...

The above is my requirement .........kindly look over the same ...

Sarfaraz

Re: Calculated dimension problem

simsondevadoss — Fri, 13 Mar 2015 16:47:48 GMT

Pls check the option show total in dimension limits.

PFA