keeping dimension regardless of selection

[giakoum]

Hi

I have a straight table chart, with dimension called Week.

What I need to do is, regardless of selection in field Measure, I need to show this chart. If you select Value in Measure, it works fine, but if you select Quantity, the chart shows nothing as no values for Week are there.

I thought some set analysis in the expression would do it, but still the chart shows nothing when Quantity is selected. I want the chart to behave as if always Value is selected in Measure. Remember, Week is the dimension.

Forgot to mention that set analysis works, but not together with aggr function, which I need to use. Without aggr, it works, but the same expression aggregated does not work. The chart shows nothing.

How can I do that?

[giakoum · Accepted solution]

man, QlikView can be such a mind breaker...

sum({$<[Measure]={"Max Liability Value"}>}

          Aggr(

                    sum({$<[Measure]={"Max Liability Value"}>} QTY)*max({$<[Measure]={"Max Liability Value"}>} [Unit Price])

          , [Plan Week], [Supplier Code], [Item Code])

)