Create a flag

Thu, 17 Jan 2013 21:10:25 GMT

Hi,

I have tried in different ways but not with good result. Therefore I turn to the combined wisdom of community...

I have a table with visitors:

Visitors:
LOAD
            Left(Filename(), 3) as Omr,
(Filename()) as Reg,
            RecNo() as %Index,
            Patindex,
            Left(FileName(), 3) & '_' & Patindex as %IndexPnr,
            Left(FileName(), 3) & '_' & Patindex as %IndexPnrTest,
            VisitingDate,
            Left(FileName(), 3) & '_' & Patindex & '_' & VisitingDate as %IndexPnrBD,
            Year(MakeDate(Left(Besöksdatum, 4), Mid(VisitingDate, 5, 2), Mid(VisitingDate, 7, 2))) as År,
            Month(MakeDate(Left(Besöksdatum, 4), Mid(VisitingDate, 5, 2), Mid(VisitingDate, 7, 2))) as Månad,
            Day(MakeDate(Left(Besöksdatum, 4), Mid(VisitingDate, 5, 2), Mid(VisitingDate, 7, 2))) as Dag,
            WeekDay(MakeDate(Left(Besöksdatum, 4),          Mid(VisitingDate, 5, 2), Mid(VisitingDate, 7, 2))) as VeckoDag,
            If(Day(MakeDate(Left(Besöksdatum, 4), Mid(VisitingDate, 5, 2), Mid(VisitingDate, 7, 2))) = 25, 'Journal per 25:e') as Info,
     Signatur,
     Journal as VG,

%Index is unique for every visitor. But every visitor can appear multiple time in table. What's the best way to create a flag to be able to sum every unique visit with the same result as Count(DISTINCT %Index)?

Best regards

Torbjörn Ungvall (@Ungvall)

Senior Business Discovery Manager

Advectas AB

Re: Create a flag

Thu, 17 Jan 2013 21:19:39 GMT

Hi Torbjörn,

could you give an example: Input (maybe a bit simplified) and expected output?

Ciao

Klaus

Re: Create a flag

Thu, 17 Jan 2013 21:30:33 GMT

Thanks,

Uploaded a scrambled file. Sum(Flag) have to be same as Count(DISTINCT %Index)

Best regards

Torbjörn Ungvall (@Ungvall)

Senior Business Discovery Manager

Advectas AB

Re: Create a flag

frank_carlsson — Thu, 17 Jan 2013 22:04:26 GMT

Hi!

Is this what you're looking for?

Re: Create a flag

rbecher — Thu, 17 Jan 2013 22:54:45 GMT

You could use exists() and dump the order by %Index..

- Ralf

topic Re: Create a flag in QlikView

Create a flag

Re: Create a flag

Re: Create a flag

Re: Create a flag

Re: Create a flag