Set analysis and YTD

Mon, 23 Sep 2013 18:37:50 GMT

Dear All,

I need to develop the report as follows.

I have a filed called as 'value' and 'Percent'.i have to design the report in design level as follows.

value percent

10 15% (i.e total/value)

20 same formula

30 same formula

40 same formula

50 same formula

Total 150 Toatl : Here

I need first this req.

second is below.

Note : value field is coming from datasource.we have to calculate percent and we have to create the YTD,MTD script as well.

i.e. if we select the partcicular year,month then the data in the value and percent should not change.

Need data as follows :

A. up to current date (if am selecting anything in the global filters is has to show current date data only.It means it won't change the data in table as per selections.)

ID(Dim) value percent

5 10 15% (i.e total/value)

10 20 Same formula

30 30 Same

40 40 Same

50 50 Same

Total 150 Total : here

A. up to previous month (if am selecting anything in the global filters is has to show current date data only.It means it won't change the data in table as per selections.)

ID(Dim) value percent

5 10 15% (i.e total/value)

10 20 Same formula

30 30 Same

40 40 Same

50 50 Same

Total 150 Total : here

C.Based on selections :it has to show the data as per the selections.

ID(Dim) value percent

5 10 15% (i.e total/value)

10 20 same formula

30 30 same

40 40 same

50 50 same

Total 150 Total : here

NOTE : So the total 6 expression are in same chart and features have to change as per your above req.

Thanks in advance,

Ravi Teja.

topic Set analysis and YTD in QlikView

Set analysis and YTD