topic Connections in QlikView

Connections

Fri, 24 Jul 2015 14:11:27 GMT

Hi everyone!

Could you, please, help to identify and fix the following problem?

Data structure is the following:

If I click on any value of var 'lemois' (CM and CMD tables), data in the AV and Q tables are recalculated and becomes a bit wrong. At the same time I need Q and CMD tables be connected and can't change it.

Could anyone, please, advice me, something!

Thank you in advance!

Marina

Re: Connections

pokassov — Fri, 24 Jul 2015 14:17:57 GMT

Hello!

You can calculate expressions for tables Q and AV ignoring selected values in lemois.

for example

count({$<lemois=>} b10)

Re: Connections

Fri, 24 Jul 2015 14:36:36 GMT

Sergey, thanks muchly!!!

Marina

Re: Connections

Mon, 27 Jul 2015 13:58:58 GMT

Sergey,

could you, please, help me with the following problem.

I need to exclude the FIELD lemois (you've already hepled me with this) and estimate indicators only for the last month. The second condition is the following: avg({<month={"$(=max(month))"}>}FIELD).

The first one: avg({$<lemois =>}FIELD).

What operator I should use or how it should be scripted to work properly (both conditions at the same time)?

Many thanks in advance!

Marina

Re: Connections

pokassov — Mon, 27 Jul 2015 14:04:42 GMT

Hello!

avg({<lemois =, month={"$(=max(month))"}>}FIELD).

Re: Connections

Mon, 27 Jul 2015 14:14:27 GMT

Sergey, great big thank you!