topic Expressions based on the values in QlikView

Expressions based on the values

varunreddy — Mon, 06 Mar 2017 19:37:51 GMT

Hi All,

I have two fields, CDE and DQ Metrics Process ID. Each CDE is associated to multiple Process ID's.

If the CDE is associated to Process ID that starts with 3 (i.e. 30000 or 30101), then I need one expression (i.e. sum(Process ID),

else Count(Process ID).

My dimension is CDE.

Can anyone please help me with the solution?

Thanks for your help in advance!

Cheers,

Varun

hector_munoz — Mon, 06 Mar 2017 21:48:06 GMT

Hi Varun,

If I have not understood you bad, you need to sum only when Process ID starts with "3"; else count Process ID... Would it serve this?

Sum(If(Left([Process ID], 1) = 3, [Process ID], 1))

Sure I am missing something in your explanations...

Regards,
H

varunreddy — Mon, 06 Mar 2017 22:06:24 GMT

Hi Hector,

Thanks for quick response.

CDE Process ID

ABC 2000

DEF 3000

XYZ 3101

Here one CDE has two Process ID's.

I am trying to write expressions based on Process ID's.

If Process ID, starts with '3*' (i.e.3000 or 3101), then I want to write an expression sum(Process ID), else count(Process ID).

I also want to see sum(Process ID), when I select CDE (i.e. DEF or XYZ).

Please let me know, if you still have issues understanding this.

Thanks,

Varun

vishsaggi — Mon, 06 Mar 2017 22:54:33 GMT

Try this?

Dim:

CDE

Expr:

= IF([Process ID] >= 3000, Sum(TOTAL Aggr(Sum({< [Process ID] = {">=3000"} >}[Process ID]), [Process ID])), Count([Process ID]))

el_aprendiz111 — Tue, 07 Mar 2017 01:15:27 GMT

Hi,