topic Re: Unable to do filter in Straight table in QlikView

Unable to do filter in Straight table

new_user30 — Mon, 07 Jan 2019 17:54:09 GMT

Hi,

I don't know why this is happening, but on selection of a value in a particular field in Straight table, that filter is not getting applied in the chart.

ex:

sales# | Sales Type |... (+ Around 30+ fields including Dimensions and Measures)

100 | AAA | ...

102 | BBB | ....

If I select 'AAA' in the chart, the chart will still show 2 rows but with the green light indicator on 'Sales Type' will be on.

When I am looking into 'Current Selection Box', there also we can see, 'Sales Type' = 'AAA' selected.

What could be the reason for the same?

Thanks in Advance.

Re: Unable to do filter in Straight table

Nicole-Smith — Mon, 07 Jan 2019 16:03:30 GMT

Is there set analysis in any of the measures? If so, it could be ignoring selections.

Re: Unable to do filter in Straight table

new_user30 — Mon, 07 Jan 2019 17:59:01 GMT

Yeah, there are Expressions where I have used set analysis.

But the chart works perfectly if I select values in other Dimension fields which I haven't included in the set analysis.

Re: Unable to do filter in Straight table

Nicole-Smith — Mon, 07 Jan 2019 20:00:18 GMT

Yes, so it's probably expected behavior.

Example:

If you have the following as an expression:

sum({<Product={'Fruit'}>}Sales)

It will always show the sum of Sales where Product = Fruit regardless of what is actually selected in the Product field.

If you want it to take into account selections in the Product field other than Fruit, change the = to *=:

sum({<Product*={'Fruit'}>}Sales)

Re: Unable to do filter in Straight table

swapniltaz — Tue, 08 Jan 2019 03:49:16 GMT

Hi ,

Just check the definition of Measure inside chart and Table .

WHat i can see is that at Grpah level there is no aggregation thats why you are seeing two rows .

Sum( Sales ) and just Sales used in your expression in two different box(graph, chart)

Re: Unable to do filter in Straight table

new_user30 — Tue, 08 Jan 2019 05:01:59 GMT

yeah you are right, the field I am trying to show has already been used inside the set analysis which is probably causing the problem.
Thank you so much Nicole. Will try to resolve the problem now.