topic Re: Need logic help on section. in QlikView

Need logic help on section.

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

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.

Re: Need logic help on section.

Anil_Babu_Samineni — Mon, 04 Sep 2017 07:14:39 GMT

Try this?

Load * From Table Where TYPE = 'Internal';

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

Re: Need logic help on section.

lalitkgehlot89 — Mon, 04 Sep 2017 07:22:12 GMT

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.

Re: Need logic help on section.

Anil_Babu_Samineni — Mon, 04 Sep 2017 07:25:07 GMT

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?

Re: Need logic help on section.

its_anandrjs — Mon, 04 Sep 2017 07:28:58 GMT

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');

Load

From [Customer Data]

Where TYPE ='Inernal';

Load

From [Customer Data]

Where TYPE LIKE 'Inernal';

Re: Need logic help on section.

lalitkgehlot89 — Mon, 04 Sep 2017 07:31:10 GMT

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

Re: Need logic help on section.

avinashelite — Mon, 04 Sep 2017 07:33:27 GMT

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

Re: Need logic help on section.

Anil_Babu_Samineni — Mon, 04 Sep 2017 07:34:04 GMT

Are you expecting this in Script / Front End?

Re: Need logic help on section.

lalitkgehlot89 — Mon, 04 Sep 2017 07:36:18 GMT

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

Re: Need logic help on section.

its_anandrjs — Mon, 04 Sep 2017 07:40:34 GMT

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

Re: Need logic help on section.

lalitkgehlot89 — Mon, 04 Sep 2017 07:44:32 GMT

Here we can create new field with the value like.

Only Internal

Only Former

Only External

Only Miscellaneous

Re: Need logic help on section.

antoniotiman — Mon, 04 Sep 2017 07:47:26 GMT

Hi Lalit,

try this

Dimension CUSTACCOUNT

Expression

Only({<CUSTACCOUNT={"=Count({<TYPE>} DISTINCT TYPE)=1"}>} TYPE)

Regards,

Antonio

Re: Need logic help on section.

its_anandrjs — Mon, 04 Sep 2017 07:52:40 GMT

In your Excel file there is field TYPE with values Internal, Former, External, Miscellaneous if you select one of this you get the corresponding CUSTACCOUNT and if you have any more field you can filter this CUSTACCOUNT.

What is your requirement?

Re: Need logic help on section.

effinty2112 — Mon, 04 Sep 2017 08:01:42 GMT

Hi Latit,

You could try a listbox with this expression:

=Aggr(If(Count(DISTINCT TYPE) = 1,TYPE,'Multiple types'), CUSTACCOUNT)

Regards

Andrew

Re: Need logic help on section.

lalitkgehlot89 — Mon, 04 Sep 2017 08:17:17 GMT

At any end either Script or Front End, which is easy.

Re: Need logic help on section.

Anil_Babu_Samineni — Mon, 04 Sep 2017 08:24:39 GMT

Can you look other response Antonio / Andrew too? then come back to thread we will help for sure

Re: Need logic help on section.

antoniotiman — Mon, 04 Sep 2017 08:32:21 GMT

Or,

if You want Always TYPE = only 'Internal', try this

Only({<TYPE={'Internal'},CUSTACCOUNT={"=Count({<TYPE>} DISTINCT TYPE)=1"}>} TYPE)

Re: Need logic help on section.

sumeet-vaidya — Mon, 04 Sep 2017 08:53:33 GMT

Hi Lalit,

Try below in your script.

Temp1:

Load

CUSTACCOUNT,

TYPE

Resident Main_Table

Where Match(TYPE, 'Internal');

NoConcatenate

Temp2:

Load

CUSTACCOUNT,

CUSTACCOUNT AS CUSTACCOUNT_Key,

TYPE

Resident Main_Table

Where Not Match(TYPE, 'Internal');

NoConcatenate

Temp_Final:

Load

CUSTACCOUNT,

TYPE

Resident Temp1

Where Not Exists(CUSTACCOUNT_Key,CUSTACCOUNT);

Drop Tables Temp1, Temp2;

Regards,

Sumeet Vaidya