Need Help

[paulwalker]

Hi Community,

I have 2 issues, please can anyone help me...

1.  I want to show Maximum of the record for based on particular ID

suppose  i have ID=100, i want to written Maximum date record... (3rd record)

                                  

2. Suppose i have create startdate and enddate calendar.

i am select startdate:  02/10/2013

                 EndDate:  02/25/2013

Here i want to written 02/10/2013 --->  ID wise i want to written Max of Date value

                                 02/11/2013--> ID wise i want to written Max of Date value

                                  and so on

                                02/25/2013--> ID wise i want to written Max of Date value

and i want calculate FTD, WTD and MTD.

PFA,

[sujeetsingh]

1.  I want to show Maximum of the record for based on particular ID

suppose  i have ID=100, i want to written Maximum date record...

Just use function Max() to get the date.

2. Suppose i have create startdate and enddate calendar.

i am select startdate:  02/10/2013

                 EndDate:  02/25/2013

Here i want to written 02/10/2013 --->  ID wise i want to written Max of Date value

                                 02/11/2013--> ID wise i want to written Max of Date value

                                  and so on

                                02/25/2013--> ID wise i want to written Max of Date value

Create a temp table in Qlikview with Group on ID and calculating the max(date)

[paulwalker]

Please anyone can help me out......

[ramasaisaksoft]

hi why don't u use  group by id in expression?

=aggr(max([Open date]),Id)

[ramasaisaksoft]

call

1)id as u r dimension

2)expression 1 :-=aggr(max([Open date]),Id)    --->for max data

3) expression 2:=max(Amount)

check like this

[paulwalker]

Hi Rama,

Thanks for reply,

How to calculate FTD, WTD and MTD...??

in edit script???

[paulwalker]

I want max date record, not max Amount...

suppose....i want to return max date record based ID..

I want to return red line....2(Feb) month is max date..

i want to pick 100,   2/1/2013,     200

Hope you understand.....

[paulwalker]

Hi Sujeet,

please can you explain second issue...

see Startdate: 02/14/2014

End date:  05/22/2015

i want to return Max(date) record for each date based on ID

[#9]

Hi Paul,

first create a vaiable

vdemo=max([Open date])

and then

in the background color option write "

=if(max([Open date])='$(vdemo)',rgb(255,205,205))

[MarcoARaymundo]

Try this.