topic Re: Table Chart dimension should list records based on current filters but ignoring some filters in QlikView

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

Fri, 05 Jun 2015 01:55:17 GMT

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

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

awhitfield — Fri, 05 Jun 2015 09:22:08 GMT

Hi Michael,

can you upload an example QVW please?

Andy

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

Colin-Albert — Fri, 05 Jun 2015 09:24:54 GMT

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

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

Anonymous — Fri, 05 Jun 2015 09:29:05 GMT

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

hope that helps

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

Fri, 05 Jun 2015 14:00:33 GMT

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

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

Fri, 05 Jun 2015 14:12:28 GMT

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

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

awhitfield — Fri, 05 Jun 2015 14:24:44 GMT

Hi Michael,

Check out the attached NEW CHART:

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

Fri, 05 Jun 2015 14:33:11 GMT

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

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

awhitfield — Fri, 05 Jun 2015 15:14:20 GMT

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

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

Fri, 05 Jun 2015 15:32:44 GMT

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