topic Qlik Sense formula in Qlik Automate

Qlik Sense formula

pjpkumar26 — Mon, 01 May 2023 08:26:07 GMT

Hi All,

I created this formula in the application and the formula as no error,

but I get no value in the application I only get a blank hyphen - .

any suggestion what's going wrong in the formula please

(Count({<"Flag"={'Y'},"Type"={"Head Office"},[Date]={'>=$(vL.Minweek1)<=$(vL.Maxweek1)'},
[Week Commencing]=>}[ID]) )
/
(sum({<[Date]={'>=$(vL.Minweek1)<=$(vL.Maxweek1)'},[Week Commencing]=>}PTE)*.9)

Thanks,

Sudheer

Re: Qlik Sense formula

BrunPierre — Mon, 01 May 2023 08:43:06 GMT

Hi, double quotes in modifiers are used for evaluated values.

[Date]={">=$(vL.Minweek1)<=$(vL.Maxweek1)"}

Re: Qlik Sense formula

pjpkumar26 — Mon, 01 May 2023 08:47:03 GMT

Thanks for your reply

I used the double code's but still I am getting blank value, any more suggestions please

(Count({<"Flag"={'Y'},"Type"={"Head Office"},[Date]={">=$(vL.Minweek1)<=$(vL.Maxweek1)"},
[Week Commencing]=>}[ID]) )
/
(sum({<[Date]={">=$(vL.Minweek1)<=$(vL.Maxweek1)"},[Week Commencing]=>}PTE)*.9)

Thanks,

Sudheer

Re: Qlik Sense formula

BrunPierre — Mon, 01 May 2023 09:30:11 GMT

The variables must be in the same format as the date field. Perhaps like this with the appropriate format.

[Date]= {">=$(=Date(vL.Minweek1,'DD/MM/YYYY')) <=$(=Date(vL.Maxweek1,'DD/MM/YYYY'))"}