topic Re: Table in QlikView

Table

rolandg1881 — Mon, 11 Nov 2019 16:23:24 GMT

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!

Re: Table

Stoyan_Terziev — Mon, 11 Nov 2019 16:34:46 GMT

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.

Re: Table

rolandg1881 — Mon, 11 Nov 2019 16:41:55 GMT

That works perfect!

Thank you!!!!