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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
rolandg1881
Creator
Creator

Table

Hi!

I ve a question please.

In the picture below i have a table on the right side with the values form the selection "Abteilung MAS" = 300

If i change the "Abteilung MAS" to 400 the values also will change. Normaly thats ok.

But the user wants five tables on the right side where the values are fix for table 1 "Abteilung MAS" = 300 for the table 2 "Abteilung MAS" = 400 etc...

My english is not so good but i hope i can describe my problem. 😉

Do you have any idea how i can solve this?

Thanks!

 
 

example.jpg

1 Solution

Accepted Solutions
Stoyan_Terziev
Partner - Creator III
Partner - Creator III

Hi Roland,

 

You can achieve this by using a set expression to the measures in the table.

Looks like you have 3 measures which I suppose look something like:

 

Sum([Gutmenge RM])

 

 

You can copy your table and change the measures to look like this (adding a set expression):

 

Sum({<[Abteilung MAS]={400}>}[Gutmenge RM])

 

 

Keep in mind I only presume the fields [Abteilung MAS] amd [Gutmenge RM] exist in your application. You have to change those with the actual field names you are using.

 

I hope this helps!

 

P.S: You can remove the 'Totals' from your measures since given the design they are only duplicating the values.

You can also just add the dimension [Abteilung MAS] - this may resolve your issue in a much simpler way. But then if you get more values than what you want your [Abteilung MAS] to be, then you may want to do this (list all values you need):

Sum({<[Abteilung MAS]={'200','300','400','500'}>}[Gutmenge RM])

Regards,

S.T.

View solution in original post

2 Replies
Stoyan_Terziev
Partner - Creator III
Partner - Creator III

Hi Roland,

 

You can achieve this by using a set expression to the measures in the table.

Looks like you have 3 measures which I suppose look something like:

 

Sum([Gutmenge RM])

 

 

You can copy your table and change the measures to look like this (adding a set expression):

 

Sum({<[Abteilung MAS]={400}>}[Gutmenge RM])

 

 

Keep in mind I only presume the fields [Abteilung MAS] amd [Gutmenge RM] exist in your application. You have to change those with the actual field names you are using.

 

I hope this helps!

 

P.S: You can remove the 'Totals' from your measures since given the design they are only duplicating the values.

You can also just add the dimension [Abteilung MAS] - this may resolve your issue in a much simpler way. But then if you get more values than what you want your [Abteilung MAS] to be, then you may want to do this (list all values you need):

Sum({<[Abteilung MAS]={'200','300','400','500'}>}[Gutmenge RM])

Regards,

S.T.

rolandg1881
Creator
Creator
Author

That works perfect!

Thank you!!!!