topic Re: Need Help in QlikView

Need Help

paulwalker — Thu, 22 Jan 2015 16:27:41 GMT

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,

Re: Need Help

sujeetsingh — Thu, 22 Jan 2015 17:00:20 GMT

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)

Re: Need Help

paulwalker — Thu, 22 Jan 2015 17:00:50 GMT

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

Re: Need Help

ramasaisaksoft — Thu, 22 Jan 2015 18:09:58 GMT

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

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

Re: Need Help

ramasaisaksoft — Thu, 22 Jan 2015 18:35:59 GMT

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

Re: Need Help

paulwalker — Thu, 22 Jan 2015 18:53:07 GMT

Hi Rama,

Thanks for reply,

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

in edit script???

Re: Need Help

paulwalker — Thu, 22 Jan 2015 19:09:37 GMT

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.....

Re: Need Help

paulwalker — Thu, 22 Jan 2015 19:53:54 GMT

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

Re: Need Help

Thu, 22 Jan 2015 21:25:37 GMT

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))

Re: Need Help

MarcoARaymundo — Thu, 22 Jan 2015 22:07:23 GMT

Try this.

Re: Need Help

paulwalker — Fri, 23 Jan 2015 03:43:09 GMT

HI Macro,

In my particular case,

start date: 2013/01/01 EndDate: 2013/02/21

ID=101 record it should be Arrow mark record (value should should be 23).... based on select range date..

Hope you understand.............

Re: Need Help

paulwalker — Sat, 24 Jan 2015 06:40:36 GMT

please anyone can help me....

Re: Need Help

Sat, 24 Jan 2015 07:12:06 GMT

ya u have to take maximum id