Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to select particular field on choice from the table,see the question for detail

I have this table

         col1     col2    col3

A      a1        b1        c1

B      a2        b2        c2

C      a3        b3        c3 

I want this 

        c2       c3

b1     _         _

b3     _        _       

I know dragging the coloumn in vertical will do so but how will i get selected choice of b1,b3  from b1,b2,b3   and c2,c3 from c1,c2,c3

help me out

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Add listboxes for col2 and col3 and select the values you want. Or use calculated dimensions. Like =if(match(col2, 'b1','b3'),col2)


talk is cheap, supply exceeds demand