Dynamic Calculations

[#1]

Hi all ,

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

it contains three rows,

like

     FirstName                    LastName          Created_Date

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

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

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

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

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

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

"firstName668829"     ;"lastName668829"     ;"07/13/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..

[jagan]

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.

[Gysbert_Wassenaar]

See attached qvw

[#4]

Hi Sir,

Thank u for ur reply...

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

[#5]

Hi Sir,

Thank u for ur reply...

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

[Gysbert_Wassenaar]

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.

[#7]

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

Can you put an attachment for it?

[jagan]

Hi Ravi,

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

Please find attached file for solution.

Regards,

Jagan.

[SunilChauhan]

see the attched file