- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
1st table based on 1st selection, 2nd Table on 2nd Selection
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
B
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
A
B < B is selected
Table 1 Table 2
Filtered By B Blank
- Tags:
- new_to_qlikview
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
see attachment
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,
MB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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),' ')
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
my expression is an if statment
if([Month End Date]-[Created Date]>=365,'Yes','No')
How can this be written into an set expression?