Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a variable named as vTAT
I have to find the sum of vTAT based on DISTINCT MAR
Create a chart with dimension MAR and as expression
Or post your expected result..
or you can try
I want to show it in a BAR Chart with Dimension as Date , Expression as Avg of vTAT of DISTINCT MAR
Load * INLINE [
nOCONCATENATE Load MAR,
SUM(vTAT) AS vTAT
group by MAR;
Drop table tat;
Hi, vTat is a variable? and what's the expression of the variable? Maybe this works if vTAT has the same value for the same MAR:
Yes vTAT is a Variable
Below is the sample data
Need to find the average of vTAT for DISTINCT MAR using Date as Dimension
Average should be around 43:35:50
Hi, using "Avg(Aggr(vTAT, MAR))" returns 43:35:50, PFA.