Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am trying to Load below Summary table in QV but it is showing error as Invalid Expression ...
Summary: Load Queue as Q,
SubCategory as S,
Month as M,
Week as W,
If(RAG_Status='R',count(RAG_Status)) as R,
If(RAG_Status='A',count(RAG_Status))as A,
If(RAG_Status='G',count(RAG_Status))as G
Resident L2_Data group by Queue,SubCategory,Month,Week;
The RAG Status column has 3 values R A and G. Please suggest me the correct syntax.
Try this
Load Queue as Q, SubCategory as S,
Month as M, Week as W,
count( If(RAG_Status='R',RAG_Status)) as R,
count(If(RAG_Status='A',RAG_Status))as A,
count(If(RAG_Status='G',RAG_Status))as G
Resident A group by Queue,SubCategory,Month,Week;
Try this
Load Queue as Q, SubCategory as S,
Month as M, Week as W,
count( If(RAG_Status='R',RAG_Status)) as R,
count(If(RAG_Status='A',RAG_Status))as A,
count(If(RAG_Status='G',RAG_Status))as G
Resident A group by Queue,SubCategory,Month,Week;
Thanks It Worked..