topic Re: someone can help me? in QlikView

someone can help me?

Fri, 06 Feb 2015 13:08:36 GMT

This function not work very well. Is always 0 or 1 and is not able to do the subtotal. Someone knows why?

num#(ENTRY_DATE)<num#(if(weekday(today())='Mo', date(today()-10), if(weekday(today())='Sa',date(today()-9), date(today()-8)))),

nullcount(MISSION_OPEN), 0 )

sunny_talwar — Fri, 06 Feb 2015 13:22:14 GMT

Weekday returns 3 letter week name. try using Mon where you have Mo and Sat where you have Sa

Best,

Anonymous — Fri, 06 Feb 2015 13:32:28 GMT

the right part of your Expression work correct (<num#....)

I tested it

what with your first Expression num#(ENTRY_DATE) or nullcount(MISSIONM_OPEN)??

francoiscave — Fri, 06 Feb 2015 13:32:55 GMT

Hi Alfonso,

Test you function Weekday() to verify which language parameters are setting in your script.

The set statement is used for defining Script Variables.

In French :

SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';

Have fun with QV,

François