Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
infosense_devel
Not applicable

Issue on pivot table in Qlik sense Desktop

Hello,

I m new in Qlik sense ,i  have created Pivot table in Qlik Sense, but I can't add filter in Pivot table similar to excel pivots.

In excel pivot when i click on any count values so it will redirect another sheet and show details sheet of that count.

For example. I  have (user,Policy,count)

so in that we have count of user which have violation Policy on that so i want to click count than it will show particular record details in pivot Qlik sense.

Here with attached below image for better understanding.

pivot_table.png

Is this possible in Qlik sense desktop Pivot?,if yes please advise on that

How to do this in Qlik sense desktop Pivot?

Thanks

10 Replies
infosense_devel
Not applicable

Re: Issue on pivot table in Qlik sense Desktop

It is urgent for me

vinieme12
Not applicable

Re: Issue on pivot table in Qlik sense Desktop

Create another straight table to show the Data rows!

infosense_devel
Not applicable

Re: Issue on pivot table in Qlik sense Desktop

I have already create straight table but i want to click functionaliy on Pivot table in Qlik sense desktop.

How can i do in this qlik sense desktop?

shraddha_g
Not applicable

Re: Issue on pivot table in Qlik sense Desktop

the functionality which you require is yet available with qliksense.

KPI object only allows to link with another sheet.

lakshmikandh
Not applicable

Re: Issue on pivot table in Qlik sense Desktop

This is not available in Qliksense, As mentioned by vinieme12 create separate table for those detail level fields.

Not applicable

Re: Issue on pivot table in Qlik sense Desktop

Is this possible by Script on Pivot table in Qlik sense Desktop ?

ogster1974
Not applicable

Re: Issue on pivot table in Qlik sense Desktop

Have you thought about creating a drill down dimension in master items and clicking on that in your pivot to drill down to the next level?

Regards

Andy

lakshmikandh
Not applicable

Re: Issue on pivot table in Qlik sense Desktop

Not on desktop ,may be you can try mashups(QAP) in desktop and design your own pages with drill down

millan123
Not applicable

Re: Issue on pivot table in Qlik sense Desktop

Hello Infosense,

That functionality is not available in QLiksense .. So please create on master dimension and add that master dimension to the Pivot table that will work for you .

Thanks,

Clark