Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

may be like this?

Not applicable
Author

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.

Anonymous
Not applicable
Author

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
Author

Hi gareth,

thank you,

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

Anonymous
Not applicable
Author

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