topic Re: Which condition to use in QlikView

Which condition to use

bharatkishore — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have 2 tables one table is like

T1:

LOAD Modality,

Material_Code ,

PartType ,

PLANT

FROM

(qvd);

and second table is like

T2:

LOAD Modality,

[Product Group],

[System Code],

[Norm group],

Global_Norm,

CN_Norm,

RUID_Norm

FROM

(qvd);

Now in first qvd i have plant and in that plant i have CN93, ID93 ,Global, RU93 data.

Now in second qvd i have CN_Norm, RUID_Norm and Global.

Now based on first table field plant when it is CN93 i should get sum(CN_Norm) and when it is RU93 i should get sum(RUID_Norm ) and when it is not CN93 and RU93 Global should get sum(Global) .

Can you please help me how can i acheive it.

Thanks,

Bharat

Re: Which condition to use

Anonymous — Mon, 05 Mar 2018 15:30:53 GMT

Kishore,

Kindly upload the sample application or sample data here. Based on that our community experts will give you reply with possible solution..

Thanks & regards,

Venkata Sreekanth

Re: Which condition to use

bharatkishore — Mon, 05 Mar 2018 15:35:09 GMT

PFA..

Re: Which condition to use

Anonymous — Mon, 05 Mar 2018 15:37:40 GMT

Kishore,

I am assuming that , we have to write a if condition inside the expression. Before that we have to create a data modeling based on the Modality field.

Expression:

Sum(If(Palnt = 'CN93' , CN_Norm, If(Palnt = 'RU93' , RUID_Norm,Global_Norm))

Thanks & Regards,

Venkata Sreekanth

Re: Which condition to use

bharatkishore — Mon, 05 Mar 2018 15:40:06 GMT

Yes i need to write that condition but i don't know how to get the link and right because plant is from one qvd and other norms are from other qvd..

can yu please help..

Re: Which condition to use

Anonymous — Mon, 05 Mar 2018 15:40:37 GMT

Use the below expression

=Sum(If(PLANT = 'CN93' , CN_Norm, If(PLANT = 'RU93' , RUID_Norm,Global_Norm)))

Thanks & regards,

Venkata Sreekanth

Re: Which condition to use

bharatkishore — Mon, 05 Mar 2018 15:44:40 GMT

This will not work because CN_Norm is from another qvd..

Re: Which condition to use

Anonymous — Mon, 05 Mar 2018 16:34:59 GMT

Use the below expression

=Sum(If(PLANT = 'CN93' , CN_Norm, If(PLANT = 'RU93' , RUID_Norm,Global_Norm)))

Thanks & regards,

Venkata Sreekanth