Discussion Board for collaboration on QlikView Scripting.
i need to filter data in a table object, i explain
i have a query like this SELECT A,B,C,D from TABLE;
Field D values are 0-1
In table i need show only A-B-C when field d = 1
Can u help me pls?
no, i need all values, so i can't filter it in query.
Iin qv document i have 2 table object, i need to show data with d=1 in first table and d=0 in the second.
ISN'T possibile filter it in table object?
See its not possible in text object, but you can use the Straight table which actually shows the same outout as table box but with the additional filter which you want.
If you are using QV 11, then use "Alternate State". Define 2 Alternate State D0 and D1 and define 2 list boxes for D one for filter 0 values another for value 1. Now create 2 tables one with Alternate state D0 another with D1