topic Re: Straight Table Dimensions limit based on Expression in QlikView

Straight Table Dimensions limit based on Expression

vardhancse — Mon, 25 Jan 2016 04:57:43 GMT

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

Re: Straight Table Dimensions limit based on Expression

Anonymous — Mon, 25 Jan 2016 05:18:47 GMT

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

check these?

Adhoc reporting in Qlikview

Ad-Hoc Reporting in Qlikview

Re: Straight Table Dimensions limit based on Expression

tresB — Mon, 25 Jan 2016 05:30:18 GMT

Like this? PFA

Re: Straight Table Dimensions limit based on Expression

robert_mika — Mon, 25 Jan 2016 05:33:23 GMT

So you need to to hide the others rows?

Look here for what you need to do:

Hiding rows based on condition

Re: Straight Table Dimensions limit based on Expression

settu_periasamy — Mon, 25 Jan 2016 05:54:54 GMT

Check the Attachment..

Re: Straight Table Dimensions limit based on Expression

vardhancse — Mon, 25 Jan 2016 06:07:30 GMT

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.

Re: Straight Table Dimensions limit based on Expression

tresB — Mon, 25 Jan 2016 06:16:26 GMT

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

Re: Straight Table Dimensions limit based on Expression

vardhancse — Mon, 25 Jan 2016 06:57:48 GMT

Got it Tresesco.

Thank you so much for your help.

Re: Straight Table Dimensions limit based on Expression

vardhancse — Tue, 02 Feb 2016 03:44:49 GMT

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

Re: Straight Table Dimensions limit based on Expression

vardhancse — Tue, 02 Feb 2016 04:30:44 GMT

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.

Re: Straight Table Dimensions limit based on Expression

settu_periasamy — Tue, 02 Feb 2016 04:33:06 GMT

Did you try my attachment in below?