Need logic help on section.

[lalitkgehlot89]

Hi,

In given data I want to see only CUSTACCOUNT which has the TYPE only Internal on selection.

Please help me out to write the logic.

[Anil_Babu_Samineni]

Try this?

Load * From Table Where TYPE = 'Internal';

OR

Only({<TYPE = {Internal}>} CUSTACCOUNT)

[lalitkgehlot89]

Hi Anil,

My Scenario some thing like this.

All data in table box. And when I select  Internal from Type then only Internal CUSTACCOUNT should be so. and if select Former then only Former CUSTACCOUNT  should be show.

If a CUSTACCOUNT  belongs more than one Type that should not show in table data.

[Anil_Babu_Samineni]

This achieve normally - QIX engine can do that for you. No need to do any thing here? Let's assume if you are filtering Internal from TYPE then how you are seeing in your application?

[its_anandrjs]

On the front end you can try on any text object, Straight table

=Count ( {<TYPE = {'Internal'} >} CUSTACCOUNT )

On Load Script

Load

*

From [Customer Data]

Where Match(TYPE,'Inernal');

Or

Load

*

From [Customer Data]

Where TYPE ='Inernal';

Load

*

From [Customer Data]

Where TYPE LIKE  'Inernal';

[lalitkgehlot89]

Hi Anil,

With your logic data exists  in application.

CUSTACCOUNT	TYPE
GLMCTM004378	Internal
GLMCTM004379	Internal
GLMCTM004380	Internal
GLMCTM004381	Internal
GLMCTM004382	Internal
GLMCTM004384	Internal
GLMCTM004385	Internal
GLMCTM004386	Internal
GLMCTM004387	Internal

But I want to see only last three records. because above records also belongs to others Type also.

GLMCTM004385	Internal
GLMCTM004386	Internal
GLMCTM004387	Internal

[avinashelite]

In table box you can't added the expression ...try with the straight table or Pivot table

[Anil_Babu_Samineni]

Are you expecting this in Script / Front End?

[lalitkgehlot89]

Hi Anand,

With your logic data exists  in application.

CUSTACCOUNT	TYPE
GLMCTM004378	Internal
GLMCTM004379	Internal
GLMCTM004380	Internal
GLMCTM004381	Internal
GLMCTM004382	Internal
GLMCTM004384	Internal
GLMCTM004385	Internal
GLMCTM004386	Internal
GLMCTM004387	Internal

But I want to see only last three records. because above records also belongs to others Type also.

GLMCTM004385	Internal
GLMCTM004386	Internal
GLMCTM004387	Internal

[its_anandrjs]

Then what are that filter and again filter with SET analysis those rows please elaborate.