Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sravanparitala
New Contributor

Hello again! Help with Avgcounts, Min Max and Std Dev

Hi,

Can someone help me in deriving the desired output as in the attached document.

Brief Summary: I have transactions data for each day for the past 8 years  (in fact it is at timestamp level). So i would like to create a summary dashboard that shows the Count of transactions, average transactions by Month, Min transactions max transactions that happened in that month and also Standard deviation.

Thank you!

3 Replies
Employee
Employee

Re: Hello again! Help with Avgcounts, Min Max and Std Dev

Hi Sravan,

I have loaded your data with a simple script as follows:

Input:

LOAD TimeStamp,

     Month(TimeStamp) as Month,

    Year(TimeStamp) as Year,

    Date(MonthStart(TimeStamp),'MMM-YYYY') as MonthYear,

     ID

FROM [lib://Downloads/Sample Input and Output.xlsx]

(ooxml, embedded labels, header is 1 lines, table is Sheet1);

This gives you some Date dimensions to work with.

Then on the Sheets, create a straight table and add your measures..

Thread 314041.PNG

sravanparitala
New Contributor

Re: Hello again! Help with Avgcounts, Min Max and Std Dev

Thank you Lisa. Can you please share with me the qvf file that you worked on? Thanks alot for your help!

Employee
Employee

Re: Hello again! Help with Avgcounts, Min Max and Std Dev

QVF attached

Community Browser