Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Min(YourFieldName) and Max(YourFIeldName)
Please elaborate more..
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;
this looks like my data. First I would like to know how to load and calculate eg the total number of calls?
how to attach a file so you can actually see the data?
how to attach a file so you can actually see the data?
how to attach a file so you can actually see the data?
Edit your thread and you get attachment details there.
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)
These are the data and I would like first is that I can load without cross table?