topic Re: Create flag and count days in QlikView

Create flag and count days

Tue, 17 Dec 2013 10:19:26 GMT

Hi all.

I have a table who I would like to add a column with "1" as a flag for each day so I could count the days.

What is the easiest way to do that?

Tue, 17 Dec 2013 10:22:55 GMT

In your load script you could set a flag and then count this..

1 as Flag

and then count(flag)

senpradip007 — Tue, 17 Dec 2013 10:59:58 GMT

In your script either use

1 As Flag

RowNo() As RowNo

and then Count(Flag) or Count(RowNo)

sudeepkm — Tue, 17 Dec 2013 11:00:32 GMT

In your st table you may just add an expression as count(1) and the expression total should give you the total count.

Tue, 17 Dec 2013 12:50:07 GMT

Agree.

You can disregard the flag (not really needed to do a simple count) and use an expression like:

count(distinct Start_Date)

This will always be work better if you have more than one line for each date in your source data