Discussion Board for collaboration related to QlikView App Development.
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.
Output: (In a Single table)
Create a straight table with these dimensions:
and an expression
Sum(if (ValueList('Global','APAC','EMEA','LAC','NA')='Global', Aggr(sum(value),Style),
create a pivot table and add Global and region style as dimension
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.
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.
Guys, Any help on this requirement in front end. It is bit Urgent.
As i know, You need to create Dim field with in the script as Island Table
Load * Inline [
And then you must use Dimension as
Pick('Group', Dim, Region)
Then, Same as Expression
Thanks Anil for response,
I didn't get your point, Can you please elaborate some more detail.
I mean this?
If you're restricted to a front end solution then maybe a container set up as grid with two straight tables?