Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I am trying to use if statement in Edit expression window for KPI value. this:
if($(vProcess)='TRUCKLOAD',
Count({<Process={'$(vProcess)'}, BU_Cons={'CSI','FG','PRINTERS','SAM','MC'}>} distinct Process_Num),
Count({<Process={'$(vProcess)'}>} distinct Process_Num)
)
unfortunately every time got a Error in expression. I am quite new in Qlik, so anybody knows, what i doing wrong?
Thanks for help!
Can you post a screenshot of the entire Edit Expression window ??
Mostly this
if('$(vProcess)'='TRUCKLOAD',
Count({<Process={'$(vProcess)'}, BU_Cons={'CSI','FG','PRINTERS','SAM','MC'}>} distinct Process_Num),
Count({<Process={'$(vProcess)'}>} distinct Process_Num)
)
Can you post a screenshot of the entire Edit Expression window ??
Mostly this
if('$(vProcess)'='TRUCKLOAD',
Count({<Process={'$(vProcess)'}, BU_Cons={'CSI','FG','PRINTERS','SAM','MC'}>} distinct Process_Num),
Count({<Process={'$(vProcess)'}>} distinct Process_Num)
)
I already found the solution. Its the same, as you highlight with orange color. Anyway, thanks you very much.