Table Chart dimension should list records based on current filters but ignoring some filters

[#1]

Hi

I am familiar with Set Analysis used in expressions.  But got stuck when the requirement is in Dimension.

My table chart dimension is Customer Id and Expression is Sum(sales).  I have filters: Area, Region, Product, QTR etc.

In the data model, Customer table and Sales table are linked via Customer Id.  Not all customers have Sales records.  Product and QTR attributes are from Sales table.

My requirement is the table should show all customers filtered by Area and Region regardless of sales data.

Show All values selection for Customer Id did not work.

Appreciate your help.,

Thanks

[awhitfield]

Hi Michael,

can you upload an example QVW please?

Andy

[Colin-Albert]

Can you post an image of your data model from the Table Viewer, and the expression you are saying does not work.

[Anonymous]

Under Properties you Need to uncheck "Suppress Zero Values" addional to "Show all values"

hope that helps

[#5]

Hi Andrew,

Sample QVW file attached.

The Table Chart has AccountName as Dimension. This dimension should work with Region filter ignoring Product and QTR filter.

If I select Show All Values, it is ignoring Region selection as well.

For ex, If Region = NA selected, we should see only Customer1, Customer2 & Customer 3.

Customer4 and Customer5 should not be displayed.

Thanks

[#6]

Hi Rudolf,

'Show All Values' does not provide the solution I am looking for.

My Dimension - Customer Name should work with some filters, but not all filters.  If we have this requirement in Expression, we use Set Analysis.  But I could not figure out how to use Set Analysis in Dimension.

Thanks

Michael

[awhitfield]

Hi Michael,

Check out the attached NEW CHART:

[#8]

Hi Andrew

Thanks for your time.

But the solution is not correct.

Dimension Customer Name should work with Region filter, but not Product and QTR.  In your chart, if I select APJ, the chart does not produce any results, but I need to see Customer4 and Customer 5.

Expression - Sum of Sales - should work with all filters: Region, product & QTR.

thanks

Michael

[awhitfield]

There are not sales for region APJ, so if you want to see 0 values, then just untick Supress Zero-Values on the presentation tab

Andy

[#10]

Thanks Andrew.

That worked for Dimension.

But Expression - should work with all filters: Region, product, QTR.

I don't know why Product and QTR filters are 'ignored' in Set Analysis.

For ex, if I select Region=NA and Product = Product 1, I should see

Customer1 - 100

Customer2 - 0

Customer3 - 0.

If I remove Set Analysis, the whole solution did not work (even the dimension).

Thanks

Michael