Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

summing/totals after crosstable import

little example

Capture.JPG

8 Replies
Anonymous
Not applicable
Author

If your "Total Time" is a solid number ( so not a calculation) you should show it as a dimension and not as an expression. This way it will show 100 for every row.

Anonymous
Not applicable
Author

And get rit of your Downtime  Types if you want to see them add up (23 for machine A)

Jason_Michaelides
Luminary Alumni
Luminary Alumni

You could use Avg([Total Time]) instead of Sum([Total Time])

Not applicable
Author

thanks Dennis,

I cannot get rid of the different types.

It's also hard to put the totals as a number, since I need to do calculations on it :

MachineTotal TimeDowtimeUptime%
A100237777
B100376363
C100267474

etc


Maybe I have to load the table in 2 times, one time not as crosstable, and without the downtime types, and then a next time only the downtime types as crosstable, and create a common unique key to link them up?

But this looks like ambiguous programming? I think there must be easier solutions than this.

Not applicable
Author

thanks Jason,

but how do I end up (Total Time) - Downtime, to calculate Uptime?

Uptime = avg(total time) - sum(downtime) doesn't work correctly...

Anonymous
Not applicable
Author

I mean get rit of the Downtime Types as a dimension in your charts.

Then you will get 23 right?

Try this create a Strait Table:

Dimension :      Machine

Expressions:           AVG(TotalTime)

                              SUM(DownTime)

                              Column(1) - Column(2)

                              Column(3)/ Column(1) *100

Let me know if this is what you are looking for

Dennis.   

Not applicable
Author

Hi,

Why don't you just make another table of Machine and TotalTime.

and then link your TotalTime and DownTime table using the Machine.

So 2 tables can be

table1:

Machine,

TotalTime

table2:

Machine,

DowntimeTypes

DownTime

This should work for most of the scenarios.

But yes, If you have huge data Size then you may also think rather then making two tables using flags and set analysis on the same cross table only.

..

Ashutosh

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Dennis just beat me to it!  See attached