Set analysis not working with a greater than sign >

[helen_pip]

Hello

I have written some syntex, but for some reason Qlikview outs a red error line just after the -6 part of the syntex when I use a Greater than sign.  When I use an equal sign the syntex works

Could someone kidnly help me so I can write the > syntex into the expression

Count({<[18_Wks_Incomplete_Inc_Run_Number] > {$(=MAX([18_Wks_Incomplete_Inc_Run_Number])-6)}>} [18_Wks_Incomplete_Breach_Category])

Kind Regards

Helen

[swuehl]

Try

Count({<[18_Wks_Incomplete_Inc_Run_Number] = {">$(=MAX([18_Wks_Incomplete_Inc_Run_Number])-6)"}>}[18_Wks_Incomplete_Breach_Category])

[Gysbert_Wassenaar · Accepted solution]

The > character needs to be placed before the $:

Count({<[18_Wks_Incomplete_Inc_Run_Number] = {'>$(=MAX([18_Wks_Incomplete_Inc_Run_Number])-6)'}>}[18_Wks_Incomplete_Breach_Category])

[agilos_mla]

Hi,

You don't use the correct syntax:

Count({<[18_Wks_Incomplete_Inc_Run_Number]={">$(=MAX([18_Wks_Incomplete_Inc_Run_Number])-6)"}>}[18_Wks_Incomplete_Breach_Category])

[helen_pip]

Hello

Thank you for your reply

I have just read that Qlikview only recognises the = sign and with your help I made a small adjustment and it now works

I used the following and just took out the > sign before the Max statement:

Thanks for your help

Count({<[18_Wks_Incomplete_Inc_Run_Number] = {">$(=MAX([18_Wks_Incomplete_Inc_Run_Number])-6)"}>}[18_Wks_Incomplete_Breach_Category])