Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!
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
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
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.
OK thanks!!!
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.