Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

{ask}How to show detail field in Table.

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.

ask1.png

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

ask2.png

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

ask3.png

Is it possible to do this?


I enclode the qvw doc in attachment.


thanks and regards,

Ted

5 Replies
qlikmsg4u
Valued Contributor

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

may be like this?

Not applicable

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

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.

lusaxy81
New Contributor III

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

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

Not applicable

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

Hi gareth,

thank you,

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

lusaxy81
New Contributor III

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

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

Community Browser