topic Re: Logic Help in QlikView

Logic Help

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

HI ,

I need logic help on one thing..

I have data as below

Table1

BID LID

1 23

1 24

2 25

2 26

3 24

How can I get the LID count on each building

Thank s much

Re: Logic Help

vishsaggi — Wed, 23 May 2018 18:13:44 GMT

What is the issue you are facing? Count(LID) does not work ? Where are you displaying this data?

Re: Logic Help

johnca — Wed, 23 May 2018 18:19:30 GMT

Maybe like this?

Table1:

Load BID,

Sum(LID) as LID_SUM

Group By BID;

Load * Inline [ BID, LID

1, 23

1, 24

2, 25

2, 26

3, 24

];

This will results in a simple table with BID 1 = 47, BID 2 = 51 and BID 3 = 24;

BID	LID
1	47
2	51
3	24

Re: Logic Help

eduardo_dimperio — Wed, 23 May 2018 18:33:26 GMT

Could you please put some output example, to better understand?

Re: Logic Help

Anil_Babu_Samineni — Thu, 24 May 2018 03:22:11 GMT

I think, This will deserve.

Count(TOTAL <LID> BID)

Re: Logic Help

sasikanth — Thu, 24 May 2018 04:18:28 GMT

Try this,

Sum(Total <BID> LID)

Re: Logic Help

chinnuchinni — Thu, 24 May 2018 04:27:28 GMT

hi ,

try this:

load * inline [

BID, LID

1, 23

1, 24

2, 25

2, 26

3 , 24

];

Re: Logic Help

shiveshsingh — Thu, 24 May 2018 09:11:50 GMT

Can you try this?

=Sum(Total <BID> LID)

Re: Logic Help

Anil_Babu_Samineni — Thu, 24 May 2018 11:02:13 GMT

I apologies guys for telling this (Because, I really not digesting for this )

My reply is May 23, 2018 11:22 PM

shiveshsingh‌ (Replied around -- 5:11 AM)

sasikanth_narne (Replied around -- May 24, 2018 12:18 AM)

Note - If we still looking the community, Because there might be another solution (Approaches should differ) rather simply doing same expression posting then we will learn do this, Instead - If you like from some one answer is same for another you can like it

Re: Logic Help

shiveshsingh — Thu, 24 May 2018 11:09:21 GMT

Hi Anil,

I thought the expression that you shared (Count(TOTAL <LID> BID)) would not give correct result, It should be Count(TOTAL <BID> LID)) to get the count of LID

Re: Logic Help

Anonymous — Thu, 24 May 2018 11:36:38 GMT

Hi Ansh,

If you are using the logic in back end then use the following script,

Table1:

Load * Inline [ BID, LID

1, 23

1, 24

2, 25

2, 26

3, 24

];

Table:

LOAD

BID,

Count(LID) as [LID COUNT]

Resident Table1

Group by

BID;

drop table Table1;

and if you are using the logic in Front end then normal count(LID) will work in chart or table.

Re: Logic Help

vishalarote — Thu, 24 May 2018 12:15:30 GMT

Try This,

t1:

load * inline[

BID ,LID

1,23

1,24

2,25

2,26

3,24

];

load BID,

count(LID) as Count

Resident t1

group by BID;