topic Re: Current Date in QlikView

Current Date

Anonymous — Tue, 27 Mar 2018 12:41:26 GMT

Hi,

I have to calculate the sales contribution of the customers.

Am using this expression

(sum({$<DateKey={">=$(=Date(vFromDate,'YYYYMMDD'))<=$(=Date(vToDate,'YYYYMMDD'))"}, Year=, Quarter=, Month=, WeekName=, Date=, CustomerCode>} $(eSales))

- sum({$<DateKey={">=$(=Date(vFromDate,'YYYYMMDD'))<=$(=Date(vToDate,'YYYYMMDD'))"}, Year=, Quarter=, Month=, WeekName=, Date=, CustomerCode>} $(eRent)))

(sum(TOTAL {$<DateKey={">=$(=Date(vFromDate,'YYYYMMDD'))<=$(=Date(vToDate,'YYYYMMDD'))"}, Year=, Quarter=, Month=, WeekName=, Date=>} $(eSales))

-sum(TOTAL {$<DateKey={">=$(=Date(vFromDate,'YYYYMMDD'))<=$(=Date(vToDate,'YYYYMMDD'))"}, Year=, Quarter=, Month=, WeekName=, Date=>} $(eRent)))

This is working but i need to show current date's sales contribution without any selection.

Re: Current Date

sunny_talwar — Tue, 27 Mar 2018 12:45:03 GMT

May be this

(Sum({$<DateKey = {"$(=Date(Today(),'YYYYMMDD'))"}, Year, Quarter, Month, WeekName, Date, CustomerCode>} $(eSales))

- Sum({$<DateKey = {"$(=Date(Today(),'YYYYMMDD'))"}, Year, Quarter, Month, WeekName, Date, CustomerCode>} $(eRent)))

(Sum(TOTAL {$<DateKey = {"$(=Date(Today(),'YYYYMMDD'))"}, Year, Quarter, Month, WeekName, Date>} $(eSales))

-Sum(TOTAL {$<DateKey = {"$(=Date(Today(),'YYYYMMDD'))"}, Year, Quarter, Month, WeekName, Date>} $(eRent)))

Re: Current Date

shiveshsingh — Tue, 27 Mar 2018 12:46:44 GMT

What is this field?vToDate

In expression, you can put today's date in filter

Re: Current Date

Anonymous — Tue, 27 Mar 2018 12:53:30 GMT

Thanks you..

How can I create an alert if the sales contribution is greater than 10%

Re: Current Date

sunny_talwar — Tue, 27 Mar 2018 12:54:45 GMT

Like an email alert or some in the dashboard itself?

Re: Current Date

Anonymous — Tue, 27 Mar 2018 12:56:05 GMT

An email

Re: Current Date

sunny_talwar — Tue, 27 Mar 2018 13:09:31 GMT

You might be able to use nPrinting... but there might be other ways, but I have not use those so would be difficult to comment about them

Re: Current Date

Anonymous — Tue, 27 Mar 2018 13:11:50 GMT

Ok..Is it possible to show in the dashboard itself like an alert after every reload

Re: Current Date

sunny_talwar — Tue, 27 Mar 2018 13:30:48 GMT

That should be possible... May be check this out

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/AlertsDialog.htm

Re: Current Date

Anonymous — Tue, 27 Mar 2018 13:53:41 GMT

Ok..But how can I use this expression as a condition while creating an alert.

Re: Current Date

sunny_talwar — Tue, 27 Mar 2018 13:58:20 GMT

May be something like this

((Sum({$<DateKey = {"$(=Date(Today(),'YYYYMMDD'))"}, Year, Quarter, Month, WeekName, Date, CustomerCode>} $(eSales))

- Sum({$<DateKey = {"$(=Date(Today(),'YYYYMMDD'))"}, Year, Quarter, Month, WeekName, Date, CustomerCode>} $(eRent)))

(Sum(TOTAL {$<DateKey = {"$(=Date(Today(),'YYYYMMDD'))"}, Year, Quarter, Month, WeekName, Date>} $(eSales))

-Sum(TOTAL {$<DateKey = {"$(=Date(Today(),'YYYYMMDD'))"}, Year, Quarter, Month, WeekName, Date>} $(eRent)))) > 0.10

Re: Current Date

Anonymous — Wed, 28 Mar 2018 08:07:31 GMT

Hi,

I have different companies, in the same dashboard we are selecting the company name. So what if company A and B has sales more than 10%.

I have created multiple alert for different companies,

I tried like this but seems like something wrong

((Sum({$<DateKey = {"$(=Date(Today(),'YYYYMMDD'))"}, Year, Quarter, Month, WeekName, Date, CustomerCode,CompanyCode={"01"}>} $(eSales))

- Sum({$<DateKey = {"$(=Date(Today(),'YYYYMMDD'))"}, Year, Quarter, Month, WeekName, Date, CustomerCode,CompanyCode={"01"}>} $(eRent)))

(Sum(TOTAL {$<DateKey = {"$(=Date(Today(),'YYYYMMDD'))"}, Year, Quarter, Month, WeekName, Date,CompanyCode={"01"}>} $(eSales))

-Sum(TOTAL {$<DateKey = {"$(=Date(Today(),'YYYYMMDD'))"}, Year, Quarter, Month, WeekName, Date,CompanyCode={"01"}>} $(eRent))))>0.10

Re: Current Date

sunny_talwar — Wed, 28 Mar 2018 08:46:25 GMT

how about a chart where it highlights the company if the ratio is above 0.10?