topic bar chart expression calculation in QlikView

bar chart expression calculation

anatle1234 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need to create the following:

the red and blue are actually orders in Atlanta/Chicago which are belong to the current year only and having specific status.

how can I calculate orders within the current year only which will work in the expression?

I tries this:

count(if( project_status='Completed' and Year=year(today()),order_ID))/count(if(Year=year(today()),order_ID))

but I think it will not work to write like thus in bar Chart.

please help.

thanks,

Anat

lironbaram — Sun, 17 Dec 2017 10:21:32 GMT

there shouldn't be any problem using this expression in bar chart

alternatively you can use set analysis for the year part

count({< Year={"$(=year(today()))"}>}

if( project_status='Completed',order_ID))/count({< Year={"$(=year(today()))"}>}order_ID))

Anil_Babu_Samineni — Sun, 17 Dec 2017 10:30:49 GMT

You can right like below?

count(if( project_status='Completed' and Year=year(TOTAL today()),order_ID))/

count(if(Year=year(TOTAL today()),order_ID))

its_anandrjs — Mon, 18 Dec 2017 06:17:16 GMT

This expression seems correct for me,

count(if( project_status='Completed' and Year=year(today()),order_ID))/count(if(Year=year(today()),order_ID))

What error you get an result?

its_anandrjs — Mon, 18 Dec 2017 06:21:21 GMT

Why not in SET expression as well

count({< Year={"$(=year(today()))"},project_status ={'Completed'}>} ,order_ID)

count({< Year={"$(=year(today()))"}>} order_ID)