Discussion Board for collaboration related to QlikView App Development.
Hi all -
Suppose I have a table box displaying a number of values across a number of fields.
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 |
---|---|---|---|---|---|---|---|
Rocks | UNKNOWN | Dirt | Cement | John | 1000 | ADK | Accounting |
Stick | 11223 | Dirt | Sand | Dave | 1245 | ADK | Expenses |
Sticks | UNKNOWN | Water | Sand | Randy | 882 | KFL | Expenses |
Soil | 12522 | Dirt | Cement | Sue | 9912 | PLK | Accounting |
Masonry | 18297 | Water | Gravel | Larry | 9901 | KPA | Management |
Masonry | UNKNOWN | Water | Gravel | Larry | 9901 | KPA | Management |
If I just put in the fields (Column 1-8), the table would display exactly as above. What if, however, I want to display the same fields but hide all lines where the value is UNKNOWN for Column 2? Thanks!
Try with expression
If( [Column 2] = 'UNKNOWN' , ' ', [Column 2] )
As the calculation condition?
is it an option to add a listbox?
=if([Column 2]='UNKNOWN', 'UNKNOWN', 'OTHER')
No - the object must display as a table so that it can be exported as such to Excel.
Hi
You can create a calculated dimension
if( [Column 2] <> 'UNKNOWN' ,[Column 2] )
Would this be done in the Load Script, or elsewhere? There's no option for a calculated dimension in a Table Box.
right clik on your table properties in the dimensions tab , there is a button called add dimension calculated
No, there's no Dimension selection in a table box. Build a new Chart Box with Dimensions selected as the same columns in your table and add a single expression to count the lines (you can hide the expression). Now you can add a new calculated Dimension as above.