Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
Try
Count({<[18_Wks_Incomplete_Inc_Run_Number] = {">$(=MAX([18_Wks_Incomplete_Inc_Run_Number])-6)"}>}[18_Wks_Incomplete_Breach_Category])
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])
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])
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])