topic value list in table in QlikView

value list in table

Anonymous — Wed, 07 Mar 2018 07:49:19 GMT

I have two headers

Accounts

abc accuont

def account

xyz account

and so on

and another

sub account

abc_a_1

abc_a_a_2

def_a_1

def_a_a_2

xyz_a_1

xyz_a_a_2

......

so when i create table box and select these two fileds this shows like this

accounts sub account

abc account abc_a_1

abc account abc_a_a_2

where as i want like this

accounts

abc account

abc_a_1

abc_a_a_2

marcus_sommer — Wed, 07 Mar 2018 09:04:17 GMT

Try it with a pivot-table instead of a tablebox.

- Marcus

ajaysingh285 — Wed, 07 Mar 2018 17:00:53 GMT

It wont possible in Table box. you can try with pivot it will works

Thanks,

Ajay