Create calculated dimension in qliksense

[Rsaiq]

HI Experts,

I have a reuirement in qliksense as need  2 field to merge into one. I am explaining in details as below:

I have 2 existing fields

Now as per the requirement We need to merge fields with some calculations like below

 

So When i am clicking on BBB or clicking on Individual then it is working fine. But when clicking on BBB Income or BBB Cover or BBB Asset it is also selecting BBB

Could you please tell me how to ignore BBB when selecting BBB Income or BBB Cover or BBB Asset 

Thanks in advance.

[ajaykakkar93]

Hi,

Frontend you can use the below code:
=if(
WildMatch( [BBB_Individual],'BBB') and WildMatch( [Net_Network],'Income') ,'BBB Income',
if(
WildMatch( [BBB_Individual],'BBB') and WildMatch( [Net_Network],'Asset') ,'BBB Asset',
if(
WildMatch( [BBB_Individual],'BBB') and WildMatch( [Net_Network],'Cover') ,'BBB Cover',
if(WildMatch( [BBB_Individual],'Individual') and not(WildMatch( [BBB_Individual],'*income*','*asset*','*cover*')) ,'Individual',
if(WildMatch( [BBB_Individual],'BBB') and not(WildMatch( [BBB_Individual],'*income*','*asset*','*cover*')) ,'BBB',
'N/A'
))
)
)
)


Backend you can use the below code

data:

load *,

if(

WildMatch( [BBB_Individual],'BBB') and WildMatch( [Net_Network],'Income') ,'BBB Income',

    if(

        WildMatch( [BBB_Individual],'BBB') and WildMatch( [Net_Network],'Asset') ,'BBB Asset',

        if(

            WildMatch( [BBB_Individual],'BBB') and WildMatch( [Net_Network],'Cover') ,'BBB Cover',

if(WildMatch( [BBB_Individual],'Individual') and not(WildMatch( [BBB_Individual],'*income*','*asset*','*cover*')) ,'Individual',

            if(WildMatch( [BBB_Individual],'BBB') and not(WildMatch( [BBB_Individual],'*income*','*asset*','*cover*')) ,'BBB',

            'N/A'

            ))

        )

    )

) as MergeField;

load 

[BBB/Individual] as [BBB_Individual] ,

[Net/Network] as [Net_Network] ;

Load * Inline [

BBB/Individual,Net/Network

BBB,Income

Individual,Income

Individual,Cover

BBB,Cover

BBB,Asset

];

exit Script;

[Rsaiq]

Hi @ajaykakkar93 

Thanks for your reply !!!

Everything is working fine but I am getting issue on 5th line of the expression. That line is not coming in the front end, I am wondering how this is happening.

Whatever line I am placing on last it is disappering on the front end. Some of the scenarios  I am atatching here.

1.

2.

Same is happening with 'Individaul' or 'BB Income' or 'BBB Cover' is placing on last line in the expression.

Could you kindly assist here. Thank You

[vikasmahajan]

hi,

you can make use of indirect set analyis  refer following post for the same.

https://community.qlik.com/t5/QlikView-App-Dev/Indirect-Set-Analysis-for-P-and-E/td-p/522117

Vikas

[Rsaiq]

Hi @vikasmahajan 

Could you please create expression here using P() or E() as I am new to qliksense and I am confused by seeing that post.Thanks

[ajaykakkar93]

Hi,
do you have value in ignoring '*income*','*asset*','*cover*' in BBB ..

[Rsaiq]

Hi @ajaykakkar93 

I dont have '*income*','*asset*','*cover*' in BBB.

[ajaykakkar93 · Accepted solution]

hi,

I understand your requirements. You can create a link table to achieve this. The code below will be helpful.

data:

load 

[BBB/Individual]&[Net/Network] as %key,

[BBB/Individual] as [BBB_Individual] ,

[Net/Network] as [Net_Network] ;

Load * Inline [

BBB/Individual,Net/Network

BBB,Income

Individual,Income

Individual,Cover

BBB,Cover

BBB,Asset

];

linkTable:

load %key,

filter

;

load 

[BBB/Individual]&[Net/Network] as %key,

[BBB/Individual] as [BBB_Individual] ,

[Net/Network] as [Net_Network],

filter;

Load * Inline [

BBB/Individual,Net/Network,filter

BBB,Income,BBB Income

Individual,Income,Individual Income

Individual,Cover,Individual Cover

BBB,Cover,BBB Cover

BBB,Asset,BBB Asset

BBB,Income,BBB

BBB,Cover,BBB

BBB,Asset,BBB

];

exit Script;

[Rsaiq]

Hi @ajaykakkar93 

Thank you so much ,It is now perfectly working !!!

[ajaykakkar93]

I appreciate it and hope it helped keep learning.