How to hide rows in straight table?

[#1]

Hi,

I have installed Qlik View 9.0 Personal Edition and have recently started working on Qlik view.

I have developed a dashboard containing 2 straight tables A and B. In straight table A i display rows where in the last column i display color status as red / green / yellow etc. . Now, when i click a column in any row in straight table A, straight table B gets updated based on my selection in straight table A.

Now my requirement is, if i have green color in status column in any row in straight table A, and then i click this row in straight table A, i need to hide all the rows in straight table B even though i have the data to display in straight table B, hope i am clear.

How to do this in straight tables?

Appreciate any help in this regard.

Thanks and Regards

Anurag

[johnw]

It's going to depend a lot on specifics, but I can give you an example.

Let's say your have a "Status" field with values 'red', 'green', 'yellow' and so on that you use to set the color in table A. Before you select anything, "Status" is null(), since it has multiple possible values. When you select a row, it will be the color of that row. So if you select a green row, "Status"='green'.

We can then use that fact in table B. Let's say table B has one expression, sum(Sales). If you change this to if("Status"<>'Green',sum(Sales)), then it will return null() when you've selected a green row. Suppress null values (should be the default), and all your rows in table B will disappear when you select a green row in table A.

[#3]

Hi John,

I was going through the post given by you. I am also in a similar situation but I am not able to go forward.

I have two time formats - SS time format and PP time format. For a single PP time format there can be multiple SS time format. This is how my pivot table should look like.

SSTimeFormat	PP TimeFormat	201010	201011	201012
201010	?	68.52%	-	-
201011	?	68.52%	71.96%	-
201012	?	68.52%	71.96%	64.75%
201101	?	68.52%	71.96%	64.75%
201102	?	68.52%	71.96%	64.75%

But in my SS Time Format, data is present from year month 199001(1990-01) till 201102(2011-02). So when I select the suppress null values and show all values in the table properties for SSTimeFormat, I am getting the following table.

SSTimeFormat	PP TimeFormat	201010	201011	201012
200912		-	-	-
201001		-	-	-
201002		-	-	-
201003		-	-	-
201004		-	-	-
201005		-	-	-
201006		-	-	-
201007		-	-	-
201008		-	-	-
201009		-	-	-
201010	?	68.52%	-	-
201011	?	68.52%	71.96%	-
201012	?	68.52%	71.96%	64.75%
201101	?	68.52%	71.96%	64.75%
201102	?	68.52%	71.96%	64.75%

Here data is displayed from the initial date present in the database. So I wanted data only from 201010 till 201102 as shown in the diagram above. This is because my amount field is there only from 201010. So I tried doing a suppress null check box selection but after doing this even my 201101 and 201102 values are disappearing since they do not have any data and the data shown in the chart is the carried forward data.

Please go through this and let me know if you can help me or not. Expecting all cooperation from your side.

Thanks and Regards

Joseph