Filter condition based on the changed properites inside the pivot table for a particular id between 2 date fields

[#1]

Hi,

For a tabulation inside the pivot table, i want to set a filter condition

1. to show changed properties  : based on the status (this is explained inside the excel which i have attahced)

2. to show all the columns

For better understanding please find the attached excel sheet

[its_anandrjs]

Hi,

Use a Flag field for this and use this option in the front end.

Thanks & Regards

[its_anandrjs]

Hi,

What is your Changed Properites let me know

Thanks & Regards

[#4]

As you can see the status has been changed to from one state to another state for a particular ID between 2 dates.

These details must be filtered out when we select the filter condition : show changed properties

[its_anandrjs]

Hi,

What is the condition that the data in excel showing in pink color for Changed Properties and rest of the selection comes in show all columns. There is 2 way either you create a Flag in load statement and 2 one by conditionally create a list box and shows two option there like 'Changed Properites','Show all columns'.

Thanks & Regards

[#6]

Hi Anand,

I don't think I understand what you were trying to convey.

I have attached a qvw for the same requirement.

If it's not much trouble can I get the logic implemented in the workbook and given to me.

Ty, Sonia

[bgerchikov]

Hi Sonia,

I suggest to setup a flag for IDs that have status changed. By selecting this flag you will be able to change the view as desired.

Please review attached.

[its_anandrjs]

Hi,

I mean to say that don't know you have any flag field or not but by this code you can do that

Temp:

LOAD * Inline

[

ID, Date, Value, Status1,Filter_Flag

1, Date 1, xx,    Done, 2

1, Date2, yy,    Done, 2

2, Date 1, fef,    Proposed,1

2, Date2, dfdf, Done, 1

3, Date 1, fdf, Draft, 1

3, Date2, csdc, Done,  1

4, Date 1, dfs, Committed, 2

4, Date2, gfbg, Committed, 2

];

Data:

load

*,

if(Filter_Flag = 1, 'Changed Properites','Show all columns') as F_Flag

Resident Temp;

DROP Table Temp;

Thanks & Regards

[#9]

Hi Boris,

This works admirably well except I am not able to view all the columns when I select the flag value '0'.

When I select '0' I want all the columns to be populated in my tabulation.

Could you please help me out here.

Br, Sonia.

[#10]

Hi Anand,

I see that you have set the filter_flag in the inline part of the script.

In any way you can make it outside the inline part and give me the desired result?

Br, Sonia.