Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
infosense_devel
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
infosense_devel
Creator II
Creator II
Author

It is urgent for me

vinieme12
Champion III
Champion III

Create another straight table to show the Data rows!

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
infosense_devel
Creator II
Creator II
Author

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
Partner - Master III
Partner - Master III

the functionality which you require is yet available with qliksense.

KPI object only allows to link with another sheet.

lakshmikandh
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 ?

ogster1974
Partner - Master II
Partner - 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

lakshmikandh
Specialist II
Specialist II

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

millan123
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