topic Re: Only show totals in straight table in QlikView

Only show totals in straight table

Thu, 30 Oct 2014 11:02:43 GMT

Hi All,

Is there a way to only show the total in straight table?

Thank you in advance

Re: Only show totals in straight table

MK_QSL — Thu, 30 Oct 2014 11:04:24 GMT

Yes... consider that you have Customer vs Sales data in your data model..

create a straight table without any dimension and use expression as SUM(Sales) and label it as TotalSales...

Re: Only show totals in straight table

its_anandrjs — Thu, 30 Oct 2014 11:04:29 GMT

Write Total with Expression

Sum(Total Sales)

Sum(Total YourMetricNameHere )

Regards

Anand

Re: Only show totals in straight table

Thu, 30 Oct 2014 11:18:01 GMT

Hi Both,

Thank you for your response,

Perhaps if I explain in more details.

I have a project ID, date created. I wanted to know how many days it had been created then total the number of projectIDs that had been created for 180+ days.

This is where I have got to so far

To calculate the second column I did-

Interval((Date(Today()))- (sum(Created)), 'd')

To calculate the last column I did-

If(Interval((Date(Today()))- (sum(Created)), 'd')>180, 1, 0)

However I only want one box showing the total number of Product IDs over 180 days old.

Thank you!

Re: Only show totals in straight table

MK_QSL — Thu, 30 Oct 2014 11:52:57 GMT

=SUM(IF(Aggr(Interval(Today()-Created,'d'),[Project ID])>=180,1,0))

Re: Only show totals in straight table

Thu, 30 Oct 2014 12:13:55 GMT

You are a genius!!!

Thank you very much!