Comparion of two subfileds of fields

[Anonymous]

Hello,

I have one doubt. I am not able to compare subfields of two columns and to show result as True if matched/existed and False if not.

Can you help in this.

[maxgro]

if(left(field1,3) = left(field2,3), true(), false())

this is an example, it depends on what's subfield

[MarcoWedel]

‌please post sample data and expected result.

[danieloberbilli]

If you are talking about the specific 'subfield()' expression:

LOAD *,

if(SubField(F1,'_',2)=SubField(F2,'_',2), True(),False()) as Compare   

;

LOAD * INLINE [

    ID, F1, F2

    1, d_e, d_e

    2, a_e, a_e

    3, f_d, f_c

];

[Anonymous]

Hi Daniel,

I appreciate your response and suggestions on below requirements.

Here is Data.

AreaYearDesignationCategoryUS 12HRA

UK 12HRAUS 12HODAUK 12HODAAUS 12HODAUS 12VCAUS 12VPAUK 12VPAAUS 12VPB

1st Requirement:

A.Show only data when any data in designation has not shared with two data

values of Category.

Example: VP shared A and B, so it hass to be not displayed.

B. If Areas (US, UK and AUS) are existed in Designation an Category, then

show as True else False.

Below is required information report in Pivot table.

I have used IsNull function for first column Designation but unable to

insert same on Category.

Designation*Category *USUKAUSHRA110HODA111VCA100

2nd Requirement:

Data which is missed in above or not satisfied condition, should display

like below in other Pivot table.

AreaYearDesignationCategoryUS 12VPAUK 12VPAAUS12VPB

Thanks,

Shiva

On Thu, May 21, 2015 at 5:16 AM, Daniel Oberbillig <qcwebmaster@qlikview.com

[Anonymous]

Hi Maco,

I appreciate your response and suggestions on below requirements.

Here is Data.

AreaYearDesignationCategoryUS 12HRA

UK 12HRAUS 12HODAUK 12HODAAUS 12HODAUS 12VCAUS 12VPAUK 12VPAAUS 12VPB

1st Requirement:

A.Show only data when any data in designation has not shared with two data

values of Category.

Example: VP shared A and B, so it hass to be not displayed.

B. If Areas (US, UK and AUS) are existed in Designation an Category, then

show as 1 else 0.

Below is required information report in Pivot table.

I have used IsNull function for first column Designation but unable to

insert same on Category.

Designation*Category *USUKAUSHRA110HODA111VCA100

2nd Requirement:

Data which is missed in above or not satisfied condition, should display

like below in other Pivot table.

AreaYearDesignationCategoryUS 12VPAUK 12VPAAUS12VPB

On Thu, May 21, 2015 at 3:49 AM, Marco Wedel <qcwebmaster@qlikview.com>

[Anonymous]

Hi Massimo,

I appreciate your response and suggestions on below requirements.

Here is Data.

AreaYearDesignationCategoryUS 12HRA

UK 12HRAUS 12HODAUK 12HODAAUS 12HODAUS 12VCAUS 12VPAUK 12VPAAUS 12VPB

1st Requirement:

A. Show only data when any data in designation has not shared with two data

values of Category.

Example: VP shared A and B, so it has to be not displayed.

B. If Areas (US, UK and AUS) are existed in Designation an Category, then

show as 1 else 0.

Below is required information report in Pivot table.

I have used IsNull function for first column Designation but unable to

insert same on Category.

Designation*Category *USUKAUSHRA110HODA111VCA100

2nd Requirement:

Data which is missed in above or not satisfied condition, should display

like below in other Pivot table.

AreaYearDesignationCategoryUS 12VPAUK 12VPAAUS12VPB

>

[MarcoWedel]

please post your sample data in a proper table format, e.g. using the in-built table editor of this page:

Header 1	Header 2	Header 3

thanks

regards

Marco