topic Re: Dynamic Calculations in QlikView

Dynamic Calculations

Fri, 20 Nov 2020 18:02:30 GMT

Hi all ,

I am New . I have some set of data. following is attached the Excel file of it..

it contains three rows,

FirstName LastName Created_Date

"firstName195224" ;"lastName195224" ;"05/27/2014"

"firstName195224" ;"lastName195224" ;"05/23/2014"

"firstName199438" ;"lastName199438" ;"08/02/2014"

"firstName668829" ;"lastName668829" ;"07/13/2014"

what i want is to find the Max created date of each user and the count of users in that date.

Excepted result

Last Created_Date TotalCount FirstName

15/4/2014 5 firstName195224

firstName199438

firstName668829

firstName668830

firstName668432

18/5/2014 1 firstName666543

22/5/2014 3 firstName123456

firstName654322

firstName766554

All the sample output shown above is random, it is not relevant to above sample data.

Need to create a tree map showing the Latest_interaction Date and the count of Users following in that Date

Please give me some solution for this problem..

Thanks in advance..

Re: Dynamic Calculations

jagan — Wed, 24 Dec 2014 08:09:06 GMT

Hi,

Try like this

Data:

LOAD

FirstName,

LastName,

Created_Date

FROM ExcelFile;

MaxDateByUser:

LOAD

FirstName,

Max(Created_Date) AS Created_Date,

1 AS MaxDateFlag

RESIDENT Data

Group By FirstName;

Now in front end

Diemsnion:

Created_Date, FirstName

Expression:

Count({<MaxDateFlag ={1}>}FirstName)

Hope this helps you.

Regards,

Jagan.

Re: Dynamic Calculations

Gysbert_Wassenaar — Wed, 24 Dec 2014 08:10:32 GMT

See attached qvw

Re: Dynamic Calculations

Wed, 24 Dec 2014 08:20:17 GMT

Hi Sir,

Thank u for ur reply...

is it possible to calculate the Max date in the Table calculations instead of Script Level.?

Re: Dynamic Calculations

Wed, 24 Dec 2014 08:20:35 GMT

Hi Sir,

Thank u for ur reply...

is it possible to calculate the Max date in the Table calculations instead of Script Level.?

Re: Dynamic Calculations

Gysbert_Wassenaar — Wed, 24 Dec 2014 08:25:29 GMT

Yes, use a calculated dimension =date(aggr(max(Create_Date),firstName,LastName)). Using a calculated dimension can cause performance problems since the calculations are done in the UI instead of in the script.

Re: Dynamic Calculations

Wed, 24 Dec 2014 08:50:17 GMT

Hi i am not getting the data as i am getting with the Script..

Can you put an attachment for it?

Re: Dynamic Calculations

jagan — Fri, 26 Dec 2014 03:58:04 GMT

Hi Ravi,

Hope you are doing great! Are you working now in Qlikview?

Please find attached file for solution.

Regards,

Jagan.

Re: Dynamic Calculations

SunilChauhan — Fri, 26 Dec 2014 04:07:50 GMT

see the attched file