topic Re: Combining codes together & present the value adding both MO & NM in QlikView

Combining codes together & present the value adding both MO & NM

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

Dear Friends

If I am to combine both codes define for MO & NM together & to present value adding both, how it is done both at script level & front end. Also if the serial of the codes end with 1 such as 171,191 etc, I need to give a function to pick all codes ends with 1 as Motor Codes. Also this should be only from seventy code series such as 77151,

Thanks in advance

Re: Combining codes together & present the value adding both MO & NM

nevilledhamsiri — Wed, 19 Sep 2018 16:04:38 GMT

Refer the attachment

Re: Combining codes together & present the value adding both MO & NM

vamsee — Wed, 19 Sep 2018 19:11:35 GMT

Please find the attached and let me know if it matches your requirement.

Re: Combining codes together & present the value adding both MO & NM

vamsee — Wed, 19 Sep 2018 19:13:41 GMT

Created two more charts for visualizations.

PFA.

Re: Combining codes together & present the value adding both MO & NM

nevilledhamsiri — Sun, 23 Sep 2018 01:36:27 GMT

Hi Vamsee

Sorry for the delay in response as I was away from home. Could you please send me your working typed in the body of the reply the fact is that I cannot open your answer. I am using a personnel edition of qlik view.

Thanks

Neville

Re: Combining codes together & present the value adding both MO & NM

vamsee — Mon, 24 Sep 2018 13:39:35 GMT

Script:

LOAD
*,
SubField(TYPE, '-',1) as Combined_Type,
IF(Left(CODE,1)=7, IF(Right(CODE,1)=1, 'Yes','No'),'No') as Motor_Code;
LOAD TYPE, CODE, VALUE
FROM (ooxml, embedded labels, table is Sheet1);

UI:

Combined Type Dimension: Text(Trim(SubField(TYPE, '-',1)))

Motor Code Dimension: IF(Left(CODE,1)=7,IF(Right(CODE,1)=1,'Yes', 'No'),'No')

You can create the same dimensions as columns in the script.

Re: Combining codes together & present the value adding both MO & NM

nevilledhamsiri — Mon, 24 Sep 2018 16:02:03 GMT

Thanks Vamsee,

This is what I needed

Neville