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 to show 3 expression column's in Single row in Pivot table ?

Hi i have pivot table below is the actual format

Region
Red
amber
green
India146
Delhi390

Output:

RegionExp
India

1

4

6

Delhi

3

9

0

i want above output in Pivot table please help

8 Replies
yoganantha321
Creator II
Creator II

hi chaganti,

Kindly use cross table to get the status field and use it in pivot table.

Example:

I have 3 field tax,aadhar,passport each status in one field

crosstable (Document,Status)

LOAD EmployeeID,

TaxIDStatus as TaxID,

     AadharIDStatus as AadharID,

     PassportStatus as Passport,

Resident Employee_Info;

the table will be look like below:

Untitled.png

the data will be

Untitled1.png

the status field can be called in pivot table

I think this will be useful

hector_munoz
Specialist
Specialist

Hi Chaganti,

What is the desired output? First or second one? Could you attach a sample?

Regards,

H

Not applicable
Author

updated please check

hector_munoz
Specialist
Specialist

Hi Chaganti, could you send us the formula of each expression?

Not applicable
Author

simple expressioons

Sum(Red) ,Sum(green), Sum(Amber) and Country dimension

Anil_Babu_Samineni

Create Pivot Table and use expression as

Sum(Red) & Chr(10) & Sum(amber) & chr(10) & Sum(green)

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable
Author

its not working its only diplaying sum(Red) remaing not showing

Anil_Babu_Samineni

Strange, I have done and it's working. Go to presentation and extend cell height and then check

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)