Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
Can you help me for this query..:=Sum({<Floor(Today()-30)-Floor([Closed date])>}[No. of CV Submitted])
I wrote this expression for bar chart but it is giving error
My requirement is i want to calculate date difference from closed date to last 30 days for resumes submitted column
Please help me out from this
swuehl stalwar1mbaeyens jagan
Thank you in advance
Does 134 looks like the number you would get from the sample file based on the condition you need?
Script
Table:
LOAD RecruiterName,
Skillname,
Date(Date#([Closed date], 'DD-MMM-YYYY')) as [Closed date],
"[No. of CV Submitted]" as [No. of CV Submitted],
Placed
FROM
[..\..\Downloads\CH09_20180809_171052.xls]
(biff, embedded labels, table is Sheet1$);
Basically, your date was read as a string by Qlik and that is why I used Date#() function to help interpret it as a date field....
and then used this
=Sum({<[Closed date] = {"$(='>=' & Date(Today()-30))"}>} [No. of CV Submitted])
Are you looking for date difference or are you counting/summing the number of cv submitted here? What is the goal?
Hi Sunny
I want to show how many resumes submitted between closed date column to 30 days before today
In that case... try this
=Sum({<[Closed date] = {"$(='>=' & Date(Today()-30))"}>} [No. of CV Submitted])
that means i want to sum of resumes submitted between those two dates
I think, This is what you are stating. Can you check this?
=Sum({<[Closed date] = {">=$(=Date(Max([Closed date])-30))<=Max([Closed date])"}>} [No. of CV Submitted])
It's not giving any data, it is showing no records to display
What is the format for Closed date? Is it a date or timestamp field?
Hi Anil,
This is also not showing any result, I want to show the sum of resumes submitted between closed date column to 30 days before today's date
I have taken the data from sql server and i think that column data type is varchar