Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

QLik Sense: show window with detail

Hi,

I have a pivot table where for each agent view the numbers contracts.

It possible you can view details of contracts with a double-click on grouped column?

Thanks

Francesco

5 Replies
simotrab
Contributor III

Re: QLik Sense: show window with detail

Hi Francesco,

could you give more informations about your data?

I mean, it could be useful to have your data structure and maybe an upload of your app -also with simulated data with a load inline-.

However maybe you can add more than a column on the right panel of the pivot table, so you'll can be able to see more details.

Here an example

     load*inline

     [agent,numberofcontracts,date,type

     a,1,2014,A

     b,2,2014,A

     c,3,2014,B

     d,1,1,2015,B

     e,2,2,2015,B

     f,5,5,2015,B

     ]

     ;

Then in a pivot you can add as columns agent and type -as a detail-, and sum(numberofcontracts) as measure.

This is what I imagined reading your question!

Not applicable

Re: QLik Sense: show window with detail

First of all thanks!!!

Example my table Pivot:

Cod. Agent | Agent                         | Num. Contract

A                    Diana                         3

B                    Laura                         69

When I click in pivot table number 3 I would like to see:

--------------------------------------------------------------------------------------

Detail contract Diana:

Date               | Cliente                         | .....

12/03/16          Alfa srl

19/07/16          Beta snc

15/08/16          Gamma spa

-------------------------------------------------------------------------------------

I would not make it with the subject in hand but with a window. it's possible?

Thanks

simotrab
Contributor III

Re: QLik Sense: show window with detail

You are welcome!

Unfortunately I think you cannot do something like that.

Maybe with an extension you'll be able to apply those ideas!

I

have found this

Qlik Branch

Here how to import extensions on Qlik Sense:

https://help.qlik.com/en-US/sense/3.0/Subsystems/ManagementConsole/Content/import-extensions.htm

Here for desktop:

Playing with Extensions in Sense

Maybe it could be useful. If you are a good Javascript writer, you can create your own.

Not applicable

Re: QLik Sense: show window with detail

OK thanks!!!

Highlighted
gferran
New Contributor III

Re: QLik Sense: show window with detail

Francesco,

sometimes I am using a table with a calculation condition. Your calculation condition could be:

count(distinct Agent)=1

You can find the calculation condition in Add-ons | Data handling

If the conditions is not true then the object has no data. Is not the best solution but it works.

Regards.