topic Re: Filter condition based on the changed properites inside the pivot table for a particular id between 2 date fields in QlikView

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

Tue, 18 Mar 2014 10:15:32 GMT

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

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

its_anandrjs — Tue, 18 Mar 2014 10:22:45 GMT

Hi,

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

Thanks & Regards

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

its_anandrjs — Tue, 18 Mar 2014 10:25:28 GMT

Hi,

What is your Changed Properites let me know

Thanks & Regards

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

Tue, 18 Mar 2014 10:39:29 GMT

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

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

its_anandrjs — Tue, 18 Mar 2014 11:20:24 GMT

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

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

Tue, 18 Mar 2014 13:52:25 GMT

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

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

bgerchikov — Tue, 18 Mar 2014 17:14:48 GMT

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.

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

its_anandrjs — Tue, 18 Mar 2014 18:04:42 GMT

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

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

Thu, 20 Mar 2014 05:22:05 GMT

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.

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

Thu, 20 Mar 2014 05:23:46 GMT

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.

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

bgerchikov — Thu, 20 Mar 2014 14:58:55 GMT

Hi Sonia,

To accommodate this I've created two expressions with show conditions.

Please review attached.

Thanks!

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

Fri, 21 Mar 2014 05:15:08 GMT

This is perfect !

You are a saviour !

Thank you so much !