Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Connections

Hi everyone!

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

Data structure is the following:

Data structure.png

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

5 Replies
pokassov
Valued Contributor

Re: Connections

Hello!

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

for example

count({$<lemois=>} b10)

Not applicable

Re: Connections

Sergey, thanks muchly!!!

Marina

Not applicable

Re: Connections

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

pokassov
Valued Contributor

Re: Connections

Hello!

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

Not applicable

Re: Connections

Sergey, great big thank you!

Community Browser