Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Need help on a simple straight table

Hi Team,

I have a simple straight table to display. However the catch is I need to group the columns based on certain criteria.

My data looks like:

MonthAreaNumber
JanA: Pass100
JanA: Fail10
JanA: No Run20
JanB: Pass200
JanB: Fail10
JanB: No Run50

 

What I want is: 

 A  B  
MonthA: PassA: FailA: No RunB: PassB: FailB: No Run
Jan10010202001050

 

The need is to add an additional row which shows the  grouping A and B

 

Can you please guide me how is this possible.

Please note that I need a Straight table and not a Pivot table

 

Thanks

 

7 Replies
Highlighted
Digital Support
Digital Support

The only way I see of accomplishing this is to actually load the A and B data into separate fields in the load script, so you can separate things that way, I believe that is the only way this will make it possible to do what you want in a straight table chart...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Highlighted
Creator
Creator

Hi BrettBleess,

I have loaded A and B separately in the load script, now the problem is how I can have the A and B displayed on the top row (highlighted in red) for Straight Table

 A  B  
MonthA: PassA: FailA: No RunB: PassB: FailB: No Run
Jan10010202001050

 

Data loaded now:

MonthParentAreaNumber
JanAA: Pass100
JanAA: Fail10
JanAA: No Run20
JanBB: Pass200
JanBB: Fail10
JanBB: No Run50

 

 

Highlighted
Digital Support
Digital Support

You misunderstood where I was going with things! 🙂  You need a Parent A and Parent B field, separate field for each of those...  Hopefully that makes things click, only way I see to do what you want to do, which may make the data model a bit ugly, but I think it should work.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Highlighted
Creator
Creator

Hi, I am not sue if I understand this properly.

Is it possible for you to give a simply dummy example.

 

 

Thanks

Highlighted
MVP & Luminary
MVP & Luminary

Make a Pivot Table with Month, Parent, Area as Dimensions.  Sum(Number) as Expression. 

Drag Parent & Area to the upper horizontal. 

Check "Always Fully Expanded" in presentation. 

See attached example qvw. 

2020-01-06_17-43-28.png

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Highlighted
Creator
Creator

Hi rwunderlich,

The problem I am having now is I guess the cartesian product join.

I am loading data from 2 tables - one from excel and another inline.

Excel data:

Load 

Month,

A_Pass,

A_Fail,

B_Pass,

B_Fail

from <excel file>

Inline Data:

Load * inline
[
Area, Parent
A_Pass, A
A_Fail, A
B_Pass, B
B_Fail, B
];

 

This is what I am getting if I create a pivot table

Untitled.png

This is what I want, Parents A and B should be grouped properly.

Untitled.png

Highlighted
MVP & Luminary
MVP & Luminary

In your previous posts you showed a field named "Area" with values "A: Pass", "A: Norun", etc.  And a field named "Number" that held the value.  Your last posted script showed loading fields named "A_Pass", "A_Fail" etc and no Number field.  So which is your data structure?  Can you post a sample data file and/or qvw?

-Rob