Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Need to create a straight table

Hi

 I have requirement below. I need to create a table based on the excel data, I have given the requirement in the excel .

can anyone please help

 

ProductMonthReferedRefreerd%  MY REqUIREMENT    
Cards18-Jan12323% By Product  Actuals   
Loans18-Jan3438%  18-Jan18-Feb18-Mar18-Apr 
Cards18-Feb5423% Cards     
Loans18-Feb4338% Referred Volumes123545423 
Cards18-Mar5423% Referred23%38%23%28% 
Loans18-Mar12338% Loans     
Cards18-Apr2323% Referred Volumes344312323 
Loans18-Apr2338% Referred23%38%23%38% 
Cards18-May12323%       
Loans18-May43238%         
Cards18-Jun56723%       
Loans18-Jun34238%       
Cards18-Jul3223%       
Loans18-Jul1238%       
Cards18-Aug1223%       
Loans18-Aug2338%       
           
           
Labels (1)
2 Replies
Highlighted
Employee
Employee

Re: Need to create a straight table

To get the output you need a pivot table to do the grouping.

Product and Month as Dimensions.

Sum(Refered) as Expression and sum(Refreerd%) as Expression.

Expand Product column. Sort Month by load order.

pivot.PNG

 

Highlighted
Digital Support
Digital Support

Re: Need to create a straight table

In addition to what Lisa gave you, the following Design Blog may prove helpful too:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083

Here is the base URL if you want to do some further searching on your own there, there are over 700 posts from our experts and most are how-to based.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

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.