Highest count in a week

[#1]

Hi all,

i have a two tables coursecompletion and signup activitylog.

coursecompletion table:                                     

course_completed                    Date

0                                      10/05/2015

1                                       10/05/2015

0                                      10/05/2015

1                                       10/05/2015

1                                       11/05/2015

1                                       11/05/2015

1                                        11/05/2015

0                                        11/05/2015

1                                        12/05/2015

1	12/05/2015
1	12/05/2015
1	12/05/2015
1	12/05/2015
1	12/05/2015
1	12/05/2015

signupactivitylog Table:

user_signed                      Date

0                                      10/05/2015

1                                       10/05/2015

0                                      10/05/2015

1                                       10/05/2015

1                                       11/05/2015

1                                       11/05/2015

1                                        11/05/2015

0                                        11/05/2015

1                                        12/05/2015

1	12/05/2015
1	12/05/2015
1	12/05/2015
1	12/05/2015
1	12/05/2015
1	12/05/2015

from the above two tables i need in which day count of the user_signed and course_completed is more.

Thanks,

Pramod

[#2]

hi jagan,

I dint get you. may be you are explaining for qlikview. i am using qliksense. please check it and help.

Thanks,

pramod