About Dimension

[sarfaraz_sheikh]

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

[robert_mika]

The first two IF statement cancel the 3 one

Once you find 75 or 80 you expression stops here.

How does your Status ID data look like?

[sarfaraz_sheikh]

Dear Robert,

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

[robert_mika]

If you attached few examples it would be easier to give answer

[sarfaraz_sheikh]

Suppose consider below data

Staus_ID     premium

80               1000

75                500

90                 400

103               700

80-Insure Reject

75-Follow Up

combination of 80 and 75 is = Sales closed Final

and my requirement is 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')))

then it should show like belew

Staus ID                80(Insurer Reject)          75(follow_up)                    Sales_Closed_final(80 and 75 both included)

Sum(premium)          1000                            500                                               1500

hope the requirement is clear to you !!!!!!!!

Sarfaraz

[PrashantSangle]

Hi,

For This You have to use Apply map()

Regards,

[sarfaraz_sheikh]

Dear Max,

can you keep any example for my understanding .........

Its urgent ......please help !!!!!!

Sarfaraz

[PrashantSangle]

Hi,

Visit below link

http://community.qlik.com/message/420768#420768

Regards

[Peter_Cammaert]

If STATUS_ID contains multiple codes, just apply Boolean logic:

if (Wildmatch(STATUS_ID,75) and Wildmatch(STATUS_ID,80), 'Sales_Closed_Final',

    if (Wildmatch(STATUS_ID,75), 'Follow_Up',

        if (Wildmatch(STATUS_ID,80), 'Insurer_Reject', 'Some Default Value')))

If you want to test single Status values in multiple rows at the same time, first concatenate them in your script using a GROUP BY LOAD statement or use the concat() function to accomplish the same in your UI.

[#10]

hi,

PFA