Straight Table Dimensions limit based on Expression

[vardhancse]

Hi,

Have one requirement is that have one straight table:

Now the requirement is that on click of All Items, it should display all the dimensions.

If we click on exceptions should show only dimensions where variance column BG colour was Yellow & Red BG .

PFA sample QVW. !

[Anonymous]

Are you looking for some kind of adhoc or custom report in QV?

check these?

Adhoc reporting in Qlikview

Ad-Hoc Reporting in Qlikview

[tresesco · Accepted solution]

Like this? PFA

[robert_mika]

So you need to to hide the others rows?

Look here for what you need to do:

Hiding rows based on condition

[settu_periasamy]

Check the Attachment..

[vardhancse]

Hi Tresesco,

Thanks for your quick reply.

Will try to implement the same in my dashboard.

Have one more issue is that, if I select any metric in table other metrics should also be visible. it should not hidden.

Is there a way to achieve the same.

Thanks in advance for your support.

[tresesco]

If you select one metric, all metrics would be visible and what would be the expression values to them? zero?

[vardhancse]

Got it Tresesco.

Thank you so much for your help.

[vardhancse]

Hi Tresesco,

Implemented your logic and its now working as per my requirement.

Once can please explain what exactly happening in the given logic. Just to understand.

please correct me if I am wrong.

We are making all Green & Grey(Which ever we need to hide) to null and restricting in table level is that correct.?

[vardhancse]

Hi Tresesco,

The expression you provided is working fine, but we are facing an issue in our main application while accessing in access point.

Like, since its an calculated dimension with aggregation function it have so many if conditions with some set analysis conditions.

Its taking so much of time and consuming large amount of RAM in our access point, can please let me know is there any alternate solution instead of aggregation function.

Thanks in advance.