Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
chou
Contributor III
Contributor III

Create an aggregate with group By and Having field with a fixed value

Hello, 

 

I want to do calculate the sum of MOPE having same NCRECRI and COPE= "DRB"

the variable DRB is a fixed value of DRB, that I have put it in the entry link.

but as a Result it doesn't take into account the cope = DRB, he is making the sum of all MOPE having same NCRECRI and COPE

Can you help me please? should I use another component?

 

0683p000009M4po.png

Labels (2)
1 Solution

Accepted Solutions
joearun4u
Creator
Creator

Hi @chou ,

 

Before passing the values into tAggregaterow, filter the values in tFilterrow i.e, COPE= "DRB". 

Try and raise your question if you still getting the same error.

 

Thanks,

Joe 

Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

 

View solution in original post

1 Reply
joearun4u
Creator
Creator

Hi @chou ,

 

Before passing the values into tAggregaterow, filter the values in tFilterrow i.e, COPE= "DRB". 

Try and raise your question if you still getting the same error.

 

Thanks,

Joe 

Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.