topic Variable in QlikView

Variable

gautik92 — Fri, 04 Sep 2015 07:12:29 GMT

I want to create variable for yesterday and i want to count no of employees present yesterday using that variable

Re: Variable

qlikmsg4u — Fri, 04 Sep 2015 07:15:21 GMT

Use this to create Yesterday variable

Let vYesterday = Date(Today()-1)

TO count no of employees use this

=Count({<YourDateField = {'$(vYesterday)'}>} Distinct EmpID)

Re: Variable

gautik92 — Fri, 04 Sep 2015 07:17:35 GMT

that is ok but how can use variable in count expr

I want to find no of employees present yesterday

Re: Variable

qlikmsg4u — Fri, 04 Sep 2015 07:18:40 GMT

=Count({<YourDateField = {'$(vYesterday)'}>} Distinct EmpID)

Re: Variable

tresB — Fri, 04 Sep 2015 07:19:43 GMT

vYesterDay = Date(Today()-1)

Count(Distinct {<Date={'$(vYesterDay)'}>} Employees)

Re: Variable

Peter_Cammaert — Fri, 04 Sep 2015 07:21:53 GMT

To supply you with a ready-to-use expression, we need to know more about the table in which you keep employee presence information.

You can use this as an example (set analysis):

=Count({<RecordDate = {"$(vYesterday)"}>} DISTINCT EmployeeID)

Re: Variable

Peter_Cammaert — Fri, 04 Sep 2015 07:22:59 GMT

Shouldn't distinct go after the set analysis spec?

Re: Variable

maxgro — Fri, 04 Sep 2015 07:23:11 GMT

expression

count({$ <Date={'$(vYesterday)'}>} IdEmployee)

variable vYesterday

=date(today()-1)

=(today()-1)

Re: Variable

Kushal_Chawda — Fri, 04 Sep 2015 07:24:46 GMT

Create variable in front end

vYesterday = date(max(YourDateField)-1,'YourDateFormat')

Now use below expression to count the employees

=Count({<YourDateField= {'$(=vYesterday)'}>} EmpID)

Without variable you can use below expression

=Count({<YourDateField= {'$(=date(max(YourDateField)-1))'}>} EmpID)

Re: Variable

tresB — Fri, 04 Sep 2015 07:28:51 GMT

Hi Peter,

It actually works both ways.

Re: Variable

qlikviewwizard — Fri, 04 Sep 2015 08:45:42 GMT

Hi Gowtham, Did you try Kush and Massimo's solution? It will works. Thank you.

Re: Variable

gautik92 — Fri, 04 Sep 2015 09:04:34 GMT

It is working

Thanks qlikviewwizard‌