topic Calculation Question in QlikView

Calculation Question

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

Good Morning,

I am working on adding a couple gauge visualizations to a dashboard I am creating and am needing a bit of help getting my expression to work. I am looking to count Orders only where OrderType = ZVK2,ZVE2, and ZVK3. I tried if(OrderType='ZVQ2', Count(OrderType)) as a test but it returns nothing.

The two fields are related and are in the same table too just in case you were wondering.

Re: Calculation Question

m_woolf — Wed, 10 Apr 2019 15:32:36 GMT

Try this:

= Count(<{OrderType={'ZVK2','ZVE2','ZVK3'}}>OrderType)

OrderType may not be the best field to count. Is there a field like "OrderNumber" that would be a primary key?

Might be better to use:

= Count(<{OrderType={'ZVK2','ZVE2','ZVK3'}}>OrderNumber)

Re: Calculation Question

JustinRamsey — Wed, 10 Apr 2019 15:37:52 GMT

Yes there is %Key_Order that would be the order number. When I try your expression converting it to the correct field name at the end it shows it as an error and returns nothing. Appears it is considering the { the start of the offence. Any ideas?

Re: Calculation Question

JustinRamsey — Wed, 10 Apr 2019 15:41:50 GMT

AHA! Figured it out!

Correct function would be COUNT({<OrderType={ZVK2,ZVK3,ZVE2}>} %Key_Order)