Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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

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

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)