Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

Hello!

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

for example

count({$<lemois=>} b10)

Not applicable
Author

Sergey, thanks muchly!!!

Marina

Not applicable
Author

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
Specialist
Specialist

Hello!

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

Not applicable
Author

Sergey, great big thank you!