Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

Straight Table Dimensions limit based on Expression

Hi,

Have one requirement is that have one straight table:

Exceptions.PNG

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. !

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

10 Replies
Highlighted
Champion
Champion

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

check these?

Adhoc reporting in Qlikview

Ad-Hoc Reporting in Qlikview

Highlighted
MVP
MVP

Highlighted

So you need to to hide the others rows?

Look here for what you need to do:

Hiding rows based on condition

Highlighted

Check the Attachment..

Highlighted
Specialist III
Specialist III

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.

Highlighted
MVP
MVP

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

Highlighted
Specialist III
Specialist III

Got it Tresesco.

Thank you so much for your help.

Highlighted
Specialist III
Specialist III

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.?

Highlighted
Specialist III
Specialist III

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.