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: 
ashok1203
Creator II
Creator II

requirement on report with totals

Hi All,

I need to create a report with all the detailed information and totals information by using the given data. Can anyone please help me to achieve the Output.

Source:

a.PNG

Output: (In a Single table)

output.PNG

AAK
1 Solution

Accepted Solutions
effinty2112
Master
Master

Hi Ashokkumar,

Create a straight table with these dimensions:

=ValueList('Global','APAC','EMEA','LAC','NA')

Style

and an expression

Sum(if (ValueList('Global','APAC','EMEA','LAC','NA')='Global', Aggr(sum(value),Style),

if(Region =ValueList('Global','APAC','EMEA','LAC','NA'),value)))

gives:

Region Style Value
Global1221150
Global3456360
Global1230390
Global1234500
APAC123080
APAC1234100
APAC1221110
EMEA122140
EMEA3456110
EMEA1234200
LAC123450
LAC3456130
LAC1230160
NA3456120
NA1230150
NA1234150

Regards

Andrew

View solution in original post

12 Replies
Chanty4u
MVP
MVP

create a pivot table and add   Global and region style as dimension 

exp: count(value)

ashok1203
Creator II
Creator II
Author

I don't have any field with Global, All the totals need to show as Label 'Global'.

All the totals i need to display in the top, if i have taken a pivot table it will shows the totals in every field data level. I need all those total information at Top and then detailed information as per the attached screenshot as output.

AAK
ankur_abhishek
Contributor III
Contributor III

Hi ,

PFA

Captudfre.JPG

ashok1203
Creator II
Creator II
Author

Thanks Ankur,

Is there any possibility to achieve in the front end only. Because we have some many reports created in front end based on these fields. So, if  i follow this method i need to edit all the existing reports. Can you please help me to achieve this in UI.

AAK
ashok1203
Creator II
Creator II
Author

Guys, Any help on this requirement in front end. It is bit Urgent.

AAK
Anil_Babu_Samineni

As i know, You need to create Dim field with in the script as Island Table

Load * Inline [

Dim

1

2

];

And then you must use Dimension as

Pick('Group', Dim, Region)


Then, Same as Expression

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)
ashok1203
Creator II
Creator II
Author

Thanks Anil for response,

I didn't get your point, Can you please elaborate some more detail.

AAK
Anil_Babu_Samineni

I mean this?

Re: Customized Value List

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)
effinty2112
Master
Master

Hi Ashokkumar,

          If you're restricted to a front end solution then maybe a container set up as grid with two straight tables?

Regards

Andrew

1.jpg