topic Re: Conditional Sum with Distinct in QlikView

Conditional Sum with Distinct

Yogita — Sat, 16 Nov 2024 04:16:47 GMT

Hello,

I am trying to sum no. of open positions based on two conditions: 1. Year and 2. for distinct job req id. The below expression is showing error. Can you please help be get it correct:

=sum({<[JobReqCreateYear]={$(vMaxReqYear)} DISTINCT [Job Req ID]>[No. of Openings])

Thanks

Yogita

Re: Conditional Sum with Distinct

pradosh_thakur — Mon, 04 Mar 2019 19:17:02 GMT

you might want to use

[Job Req ID] as the dimension

and

=sum({<[JobReqCreateYear]={"$(vMaxReqYear)"}>}[No. of Openings])

as your measure

Re: Conditional Sum with Distinct

Yogita — Mon, 04 Mar 2019 19:22:05 GMT

Thanks for your response. I am using this expression in a Text box. Not sure how to define dimensions in table box.

Can't we make it a 2 conditions Sum expression ?

Re: Conditional Sum with Distinct

pradosh_thakur — Mon, 04 Mar 2019 19:27:52 GMT

We can use two condition for sure , but Your second condition is n't really a condition. it is more or less feels like a dimension. You can use a straight table for this I guess. If this not your requirement, you can explain it with a small example.

-Pradosh