topic {ask}How to show detail field in Table. in QlikView

{ask}How to show detail field in Table.

Fri, 07 Aug 2015 08:38:17 GMT

Hi All,

I would like to ask you about chart and table,

I have qvw doc and there is any table for show the sum of company_pay.

Usually, if i choose / click one company_pay, then in the table only appear one company. like below :

But, I wanna show the detail of company_pay without sum if i click one of company_pay. like below :

Is it possible to do this?

I enclode the qvw doc in attachment.

thanks and regards,

Ted

Re: {ask}How to show detail field in Table.

qlikmsg4u — Fri, 07 Aug 2015 08:54:40 GMT

may be like this?

Re: {ask}How to show detail field in Table.

Fri, 07 Aug 2015 09:20:00 GMT

Hi K N,

thank you for your replay,

but i would like to click company_pay not currency. and if i click one of company_pay, it will show detail of company pay in detail table and the main table is hidden.

Re: {ask}How to show detail field in Table.

Anonymous — Fri, 07 Aug 2015 09:33:47 GMT

Hi Ted,

the reason as i am sure you know id that the straight table does not have a unique combination in the dimensions to break it down.

in order to do it as you would like, you can simply add more dimensions to make each row unique (namely your "Curren" field) and then in the presentations tab use the "Hide Column" function

Re: {ask}How to show detail field in Table.

Fri, 07 Aug 2015 10:08:42 GMT

Hi gareth,

thank you,

if i use your way, it will show all the detail without click the company_pay.

Re: {ask}How to show detail field in Table.

Anonymous — Fri, 07 Aug 2015 10:19:15 GMT

not a problem.

in the dimensions tab. select "curren" and check the enable condition. in there type:

GetPossibleCount(company_pay)=1

this will show the details when there is only 1 possible company_pay value