Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
vardhancse
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
tresesco
MVP
MVP

10 Replies
balrajahlawat
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

tresesco
MVP
MVP

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
Specialist III
Specialist III
Author

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
MVP
MVP

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

vardhancse
Specialist III
Specialist III
Author

Got it Tresesco.

Thank you so much for your help.

vardhancse
Specialist III
Specialist III
Author

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
Specialist III
Specialist III
Author

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.