topic count days in QlikView

count days

Sun, 16 Oct 2011 11:25:02 GMT

something easy.

I want to count the amount of activity in a web site. the data I have related with dates is 3 diffrent fields.

I want to set a graph showing how much times I can see every one of the 3 fields in a year then a quarter and a month.

my fields name is: follows, search and registers. all of them contain dates.

thank you in advance.

Asaf Cadmon

Re: count days

vgutkovsky — Sun, 16 Oct 2011 17:42:39 GMT

Asaf,

See attached. There are many possible solutions, but this would be my approach.

Regards,

Vlad

Re: count days

Sokkorn — Mon, 17 Oct 2011 01:56:23 GMT

Hi Asaf Cadmon,

Load data like this

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=DHC0N04J;Use Encryption for Data=False;Tag with column collation when possible=False];
LOAD
    Follows,
    YEAR(Follows)    AS [Year-Follows], 
    Registers,
    YEAR(Registers)    AS [Year-Registers],
    Search,
    YEAR(Search)    AS [Year-Search];
SELECT * FROM master.dbo."site use";

In bar chart create [Year-Follows] as Dimension and SUM(IF([Year-Follows]=[Year-Registers],1,0)) as Expression.

Hope this help.

Regards,

Sokkorn

count days

Mon, 17 Oct 2011 08:04:42 GMT

wow, you two did some wonderful work here!

thank you very much!!