Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

urgent

hello I'm new to Qlikview and I have a problem, I want to do calculations on a minimum such maximum data table. I loaded the array as a dynamic array but I'm struggling to get my variables and do my calculations

13 Replies
MK_QSL
MVP
MVP

Min(YourFieldName) and Max(YourFIeldName)

Please elaborate more..

its_anandrjs

From table load or in script you can get

Temp:

Load * inline

[

ID,Value

A,45

B,15

C,74

D,12

];

Noconcatenate

New:

Load

ID,

Max(Value) as MaxValue,

Min(Value) as MinValue

Resident Temp;

Drop Table Temp;

Not applicable
Author

this looks like my data. First I would like to know how to load and calculate eg the total number of calls?

Not applicable
Author

how to attach a file so you can actually see the data?

Not applicable
Author

how to attach a file so you can actually see the data?

Not applicable
Author

how to attach a file so you can actually see the data?

its_anandrjs

Edit your thread and you get attachment details there.

MK_QSL
MVP
MVP

The section where we are writing, you can find a USE ADVANCE EDITOR... (TOP RIGHT)

Select that one and you will find Attach (BOTTOM RIGHT)

Not applicable
Author

These are the data and I would like first is that I can load without cross table?