Discussion board where members can get started with Qlik Sense.
i have a two tables coursecompletion and signup activitylog.
from the above two tables i need in which day count of the user_signed and course_completed is more.
Try like this
Date(Date#(Date, 'MM/DD/YYYY')) AS Date
0 , 10/05/2015
For getting maximum course_completed date use below expression
=Date(FirstSortedValue(Date, -Aggr(Sum(course_completed), Date)))
The same way do this for User signed.
hi jagan mohan,
after using the above expression in measure i got the below result.
Can you attach sample file and your expected output, so that it would be easier to understand your requirements.
PFA of sample data.
You need to use this in text object so that you will get the date which has max Course completions.
Din't get you. would you please explain it briefly.
What is your expected output for the given data?
i need the day in which i have more count of completions?
by using the expression Sum(course_completed) in measure. i am getting the count of course completion of all the day.
but in that i need highest course completion day in last week.
date completion count
here date 14/05/2015 has highest count. i have to display that day in bar graph.
i think you have got it.
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Dimension : date_completed
Sort Tab : Select Y Value-> Descending
Dimension Limits Tab : Select "Restrict which values are displayed using the first expression" option
and select Show Only Largest and give 1 in Values text box.
Hope this helps you.