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

I want to show all the fields on single statement,find detail question below

Header 1Header 2Header 3Header 4
Field1234543545345
Field223433453443534
Field324563453434534

suppose this is my pivot table, when i'm selecting Field2 it will show like this

Header 1Header 2Header 3Header 4
Field223433453443534

but i want all the fields if i select field2.

1 Solution

Accepted Solutions
rustyfishbones
Master II
Master II

Kumar,

Is that not what my uploaded file does?

View solution in original post

19 Replies
sushil353
Master II
Master II

Hi,

while calculating your expression in pivot table ... make use of set analysis..

For example:

sum({<Header1=>}values)

replace Header1 with the actual field name.

HTH

Sushil

Not applicable
Author

Have you tried Concat ?

Not applicable
Author

yup I'm doing it but its not working,

Not applicable
Author

how can i use concat to solve this problem,can you elaborate?

rajni_batra
Specialist
Specialist

PFA..

U want it like this??

christian77
Partner - Specialist
Partner - Specialist

Hi:

Use system table.

Use $Field as dimension. The thing is that system data does not interact or filter with the data model, so you probably need something like a Report Generator.

salutes.

Not applicable
Author

attached file is not loading

christian77
Partner - Specialist
Partner - Specialist

If you want not to filter that particular field, you can set an action. When that field is selected, unselect that field.

Not applicable
Author

I got the point,but still not getting how to do it,

how will i create the action ?plz give me an example