topic Hide / UnHide Grid column based on Conditions in QlikView

Hide / UnHide Grid column based on Conditions

shumailh — Mon, 02 Aug 2010 17:23:27 GMT

Can we hide and unhide columns based on our required like the snapshot below:

Shumail

Hide / UnHide Grid column based on Conditions

Mon, 02 Aug 2010 17:31:55 GMT

I would create two tables - one with actuals and plan and the other table only with actuals. Then create a list box with two values. Hide and show the appropriate table based on the selection.

Nimish

Hide / UnHide Grid column based on Conditions

shumailh — Mon, 02 Aug 2010 17:34:20 GMT

One more thing I extracted this data from qlikview whereas you can see in the first grid the numbers for plan column was only available for jul-10, what i do is to exclude all the values for plan except july-2010 by using set analysis

sum({$<Report_Date = {'40390'}>} Fin_Amount)

but i couldn't get my required grid.

Shumail

Hide / UnHide Grid column based on Conditions

shumailh — Mon, 02 Aug 2010 17:37:09 GMT


Nimish Shah wrote:
I would create two tables - one with actuals and plan and the other table only with actuals. Then create a list box with two values. Hide and show the appropriate table based on the selection.
Nimish<div></div>

Hi Nimish,

Can you please explain this point "Then create a list box with two values. Hide and show the appropriate table based on the selection." I am not getting u.

Shumail

Hide / UnHide Grid column based on Conditions

jlassell — Mon, 02 Aug 2010 21:16:28 GMT

Here is an example QVW that will hide columns based on a user selection.

Cols are hidden/not hidden based on a condition in the presentation tab.

Hide / UnHide Grid column based on Conditions

Tue, 03 Aug 2010 00:10:26 GMT

You are right but Hide columns conditionally is possible only for straight tables and not for pivot tables. So it would depend on Shumail's requirement. From his chart it looks like he can use a straight table and do as you have suggested.

Nimish

Hide / UnHide Grid column based on Conditions

Tue, 03 Aug 2010 00:49:28 GMT

Sorry but did not realize that you wanted actuals till July and plan for July. So the solution will not work in your case.

Nimish

Hide / UnHide Grid column based on Conditions

shumailh — Tue, 03 Aug 2010 07:11:43 GMT


Nimish Shah wrote:
Sorry but did not realize that you wanted actuals till July and plan for July. So the solution will not work in your case.
Nimish<div></div>

Nimish,

Are you saying that I can implement required grid (actuals till July and plan for July) by using straight table? OR its not possible in qlikview?

Shumail

Hide / UnHide Grid column based on Conditions

Wed, 04 Aug 2010 00:29:00 GMT

Are you looking for something like what is attached in the example?

Nimish

Hide / UnHide Grid column based on Conditions

shumailh — Wed, 04 Aug 2010 10:29:45 GMT


Nimish Shah wrote:
Sorry but did not realize that you wanted actuals till July and plan for July. So the solution will not work in your case.

Nimish<div></div>

Hi Nimish,

This cross table and other load function i know, I already mentioned and in ur previous post u understand it right that I am looking for "actuals Jan10 till July10 and plan only for July10" in the grid. I am looking for hiding and unhiding fields based on conditions.

This Actual and Plan are the seperate fields as u did it in ur example but i want to hide the plan for last 6 months only wanted to display it for jul-10 whereas actual would be shown for all months.

Shumail

Hide / UnHide Grid column based on Conditions

Wed, 04 Aug 2010 10:35:37 GMT

I understand. In the sameple I have two tables. One with Actuals and Plan and in the other only actuals till June 2010 and plan for July 2010. The problem is that the expression field does not have a name in this case, since it is only a single field. Just check the figures.

If you are okay with this, I can show you how to hide and unhide the tables based on user preference.

Nimish

Hide / UnHide Grid column based on Conditions

shumailh — Wed, 04 Aug 2010 10:43:21 GMT


Nimish Shah wrote:
I understand. In the sameple I have two tables. One with Actuals and Plan and in the other only actuals till June 2010 and plan for July 2010. The problem is that the expression field does not have a name in this case, since it is only a single field. Just check the figures.
If you are okay with this, I can show you how to hide and unhide the tables based on user preference.
Nimish<div></div>

I saw the grid... and in expression dude u put actual = 0 but i wanted to show actual and plan both for jul-10, not only plan?

and yes can you share with me that how to hide and unhide the tables based on user preference. may be it would help.

Shumail