Qlik Sense formula

[pjpkumar26]

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

[BrunPierre]

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

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

[pjpkumar26]

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

[BrunPierre]

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'))"}