Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

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
Creator II
Creator II

It is urgent for me

Champion II
Champion II

Create another straight table to show the Data rows!

Creator II
Creator II

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?

Partner
Partner

the functionality which you require is yet available with qliksense.

KPI object only allows to link with another sheet.

Specialist II
Specialist II

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

Not applicable

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

Master II
Master II

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

Specialist II
Specialist II

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

Creator II
Creator II

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