topic Re: Flag to show record count in QlikView

Flag to show record count

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

Hi,

I need a flag to show records where count is more than 1.

I am trying this in the script "if(count(fieldname > 1, 1,0) as flag" or in the listbox but it's not working. I would prefer it to be outside the script.

So by clicking 1 the user gets to see the duplicates and by clicking 0 unique records.

Please advise

Thanks

Re: Flag to show record count

Kushal_Chawda — Wed, 11 May 2016 09:03:07 GMT

Data:

ID, // ID is key field

Field

FROM table;

new:

LOAD *,

if(Cnt>1,1,0) as Flag;

LOAD ID,

Count(Field) as Cnt

resident Data

group by ID;

Re: Flag to show record count

sunny_talwar — Wed, 11 May 2016 09:11:50 GMT

You can probably combine this into one like this:

Data:

ID, // ID is key field

Field

FROM table;

New:

LOAD ID,

If(Count(Field) > 1, 1, 0) as Flag

resident Data

group by ID;

DROP Table Data;

Re: Flag to show record count

Anonymous — Wed, 11 May 2016 09:19:08 GMT

Thanks Sunny, it works

Re: Flag to show record count

ashishkalia — Wed, 11 May 2016 09:20:25 GMT

Do you really want to Flag in backend.

Else you can do following:-

Make an inline table

LOAD * INLINE [

Flag

];

Create a text object and Write a logic as " if(Flag = 1, count(Field) , count(DISTINCT Field) )".
Take Flag field as selection, when you select 1 expression will show redundant result but on selecting 0 it will show Unique count. In same way you can play around any thing you are trying to show.

Re: Flag to show record count

Kushal_Chawda — Wed, 11 May 2016 09:24:11 GMT

I don't think it will make much difference. Do you think different?

Re: Flag to show record count

sunny_talwar — Wed, 11 May 2016 09:26:27 GMT

For a small set of data, no. But for a big data set with a lot of ids, preceding load can be bad. Remember our yesterday's discussion where Marcus was talking about how preceding load can slow down.

The Cost of Preceding Load | Qlikview Cookbook

Re: Flag to show record count

Kushal_Chawda — Wed, 11 May 2016 09:27:07 GMT

@sunnysahni is this solution not working?

Re: Flag to show record count

Kushal_Chawda — Wed, 11 May 2016 09:35:00 GMT

Yeah correct.