Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
infosense_devel
Contributor 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
Contributor II

Re: Issue on pivot table in Qlik sense Desktop

It is urgent for me

vinieme12
Esteemed Contributor II

Re: Issue on pivot table in Qlik sense Desktop

Create another straight table to show the Data rows!

infosense_devel
Contributor II

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?

Partner
Partner

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
Valued Contributor II

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
Honored Contributor II

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
Valued Contributor II

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

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