topic Re: 1st table based on 1st selection, 2nd Table on 2nd Selection in QlikView

1st table based on 1st selection, 2nd Table on 2nd Selection

tinkerz1 — Thu, 29 Oct 2015 12:31:54 GMT

Hi,

If I have an list box with 2 records in it and I click on one, I then what the first table on the sheet to have that first selection in an expression.

So if the list box has 2 selections and both selections have been selected then 2 table would be split by the 2nd selections in the list.

if(subfield(concat(distinct [Business Function],','),',',1)='Market',1,0)

But I can't get 'Market' to be a flexible statement

Here is my example

Field

A < A is selected

Table 1 Table 2

Filtered By A Blank

Field

A < A is selected

B < B is selected

Table 1 Table 2

Filtered By A Filtered By B

Field

B < B is selected

Table 1 Table 2

Filtered By B Blank

Re: 1st table based on 1st selection, 2nd Table on 2nd Selection

maxgro — Thu, 29 Oct 2015 12:45:46 GMT

see attachment

Re: 1st table based on 1st selection, 2nd Table on 2nd Selection

miguelbraga — Thu, 29 Oct 2015 12:49:37 GMT

Maybe you can have something like this:

1st make two variables like this:

vSelectedA with the expression like if(field='A', 1, 0)

vSelectedB with the expression like if(field='B', 1, 0)

2nd in your Table1 check the Show Conditional and add something like this:

=$(vSelectedA) = 1

3rd in your Table2 check the Show Conditional and add something like this:

=$(vSelectedB) = 1

This should do the trick...

Regards,

Re: 1st table based on 1st selection, 2nd Table on 2nd Selection

tinkerz1 — Thu, 29 Oct 2015 12:52:43 GMT

When I place this in the caption, it reads the same but wont trigger, it works for index position 1

PurgeChar(subfield(GetFieldSelections([Issue - Business Function]),', ',2),' ')&'-'&PurgeChar(subfield(concat(distinct [Issue - Business Function],';'),';',2),' ')

Re: 1st table based on 1st selection, 2nd Table on 2nd Selection

tinkerz1 — Thu, 29 Oct 2015 15:35:04 GMT

my expression is an if statment

if([Month End Date]-[Created Date]>=365,'Yes','No')

How can this be written into an set expression?