topic Re: today()-1 Problem in QlikView

today()-1 Problem

Anonymous — Tue, 17 Feb 2015 09:39:41 GMT

In set analysis Today()-1 creating problem

Explanation:

Monday-1=Sunday

But i want to display Monday-1=Friday

Networkdays

How to achieve this using set analysis

Re: today()-1 Problem

PrashantSangle — Tue, 17 Feb 2015 09:51:54 GMT

Hi,

try with if

if(weekday(datefield())='Monday',datefield-2,datefield-1)

Regards

Re: today()-1 Problem

sunny_talwar — Tue, 17 Feb 2015 10:01:14 GMT

On similar lines for what max dreamer just gave you but I feel that there should be datefield-3 if the condition is met. Here is what I have:

=If(WeekDay(Today()) = 'Mon', WeekDay(Today()-3), WeekDay(Today()-1))

Best,

Re: today()-1 Problem

Anonymous — Tue, 17 Feb 2015 10:01:41 GMT

if you want always 1 work day before actual day you can use

=firstworkday(today(),1) -> results in friday if today is monday

you can even include Holidays (as 3rd Parameter) in the calculation

Re: today()-1 Problem

leandro_gocosta — Mon, 20 Apr 2015 16:38:22 GMT

Hi,

use =date(Today()-1)

Re: today()-1 Problem

leandro_gocosta — Mon, 20 Apr 2015 16:44:56 GMT

Exemple:

Sum({<DATE = {'$(=Date(Today() - 1))'} Sales )

Re: today()-1 Problem

lucianosv — Mon, 20 Apr 2015 18:10:50 GMT

Boa tarde.

Já tentou coloca o 1 na expressão para forçar a condição?

Da maneira que está se today - 1 não estiver na seleção não vai funcionar

Enviado do meu iPhone

Em 20/04/2015, às 13:45, Leandro Gonçalves <qcwebmaster@qlikview.com> escreveu:
Qlik Community
today()-1 Problem
resposta de Leandro Gonçalves em App Development - Visualize a discussão completa
Exemple:
Sum({<DATE = {'$(=Date(Today() - 1))'} Sales )
Responda a esta mensagem respondendo a este e-mail ou vá para a mensagem em Qlik Community
Inicie uma nova discussão em App Development por e-mail ou em Qlik Community
Seguindo Leandro Gonçalves nestes fluxos: Fluxo de conexões