Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

prabhu0505
Not applicable

Aggregate Table in Qlikview

Dear All,

  For a Dashboard, I need to create an Aggregate Table. Can I create it in Qlikview and update values to it?

Your suggestions are really very much appreciated!!

Thanks & Regards,

Saravana Prabhu

3 Replies
jason_michaelid
Not applicable

Aggregate Table in Qlikview

Can you be more specific? Aggregation is certainly possible but how depends on your requirements. In the script is best, unless the aggregation will depend on user selections. What do you need to achieve and can you post a sample of your app?

prabhu0505
Not applicable

Aggregate Table in Qlikview

  Thanks for your reply..

  Actually in a table, customer id, purchase date and some other columns are there, we need to create an cutomer attrition dashboard using this table. So far that we planned to create an aggregate table as below.

Customer Attrition.bmp

jontydkpi
Not applicable

Aggregate Table in Qlikview

Hi

You can get the look you want with a pivot table. Drag one of the date headers to the top of the table to create the cross table.

You can colour the diagonal using the expression background colour. Something like

    If(month1 = month2, yellow())

(assuming month1 and month2 are the two date dimensions)

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein