IF statement in the Edit expression window.

[Ondrism]

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!

[vinieme12 · Accepted solution]

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)
)

[Ondrism]

I already found the solution. Its the same, as you highlight with orange color. Anyway, thanks you very much.