Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
ashok1203
Contributor 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
Tags (2)
1 Solution

Accepted Solutions
effinty2112
Honored Contributor

Re: requirement on report with totals

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
Esteemed Contributor III

Re: requirement on report with totals

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

exp: count(value)

ashok1203
Contributor II

Re: requirement on report with totals

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
New Contributor III

Re: requirement on report with totals

Hi ,

PFA

Captudfre.JPG

ashok1203
Contributor II

Re: requirement on report with totals

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
Contributor II

Re: requirement on report with totals

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

AAK

Re: requirement on report with totals

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

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
Contributor II

Re: requirement on report with totals

Thanks Anil for response,

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

AAK

Re: requirement on report with totals

I mean this?

Re: Customized Value List

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
Honored Contributor

Re: requirement on report with totals

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