Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how can i reflect selections in pivot table?

Hi all,

I have filters like empno,enmae,deptno.

in pivot table i need to show any one above fileter as dimension.

if you select any one of fileter then that related fileter data should be populated in pivot table.

For example if you select empno then empno should be displayed in pivot table as dimension. like that for ename,deptno also.

how can i write condition in pivot table??

1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

Hi Sanjeev,

have a look at below example.

http://community.qlik.com/docs/DOC-5404

Regards

ASHFAQ

View solution in original post

5 Replies
sushil353
Master II
Master II

Hi,

In dimension tab > Enable Condition..

You can write condition like : getfieldselection(ename) > 0 for ename dimension..

for deptno : getfieldselection(deptno)>0...

and so on..

HTH

Sushil

nagaiank
Specialist III
Specialist III

You may create a cyclic group with empno,enmae,deptno as fields and use this group as dimension in your pivot table.

sujeetsingh
Master III
Master III

ABD,

has given the way to move you can use getselection () function for this filters and then call it in a calculated dimension in pivot table

ashfaq_haseeb
Champion III
Champion III

Hi Sanjeev,

have a look at below example.

http://community.qlik.com/docs/DOC-5404

Regards

ASHFAQ

sasikanth
Master
Master

HI sanjeev ,

it seems you need info about ad-hoc reporting ,

please find the attachment

Thanks

sasi