topic Re: One chart always shows one name (dimensions) in QlikView

One chart always shows one name (dimensions)

Sxbbb — Sat, 19 Nov 2022 03:15:00 GMT

Re: One chart always shows one name (dimensions)

Vegar — Sat, 19 Nov 2022 07:29:20 GMT

You can control which dimensions to include in your calculation by using set analysis.

I am assuming your current calculation is Sum(Value). In order to make sum(Value) to only calculate for the Name: KAIMA_4W you can add a set modifier like this:

Sum({<Name={'KAIMA_4W'}>}Value)

Re: One chart always shows one name (dimensions)

Sxbbb — Sat, 19 Nov 2022 07:40:57 GMT

i tried this but if i press name=A3030#1 chart it doesn't show data I want when selecting a different name the value will be displayed.

Re: One chart always shows one name (dimensions)

marcus_sommer — Mon, 21 Nov 2022 12:45:36 GMT

You could make the assignment of names dynamically by querying the possible values of this field. This may look like:

sum({< Name = {'$(=subfield(concat(distinct Name, '|',), '|', 1))'}>} Value)

whereby the bold number is the index-number which item will be returned from the read fieldvalue-list.

Beside of this I could imagine that a grid-chart is more suitable. You could enable it within the object-properties in tab dimensions on the bottom left.

- Marcus