topic Comparing the week wise data base don the filter in QlikView

Comparing the week wise data base don the filter

manoranjan_d — Wed, 02 Aug 2017 10:47:15 GMT

Hi all,

In the attached file,

i want to display the week wise compare data in the straight table

req1:

based on the description selection in the filter, the primary compare date(two filters) has to be filtered out.

this req1 will happen automatically as per the filter selection.

req2:

when user click the primary compare date(first filter) , then duplicated primary compare date(second filter) should not be linked to each other.

example if i select the

07-01-17 in the filter 1(primary compare date) then it should not select the same date in duplicated 2nd filter (primary compare date).

req3:

now when user select two different date from two filters (primary compare date filters) or same date from the two filters two filters (primary compare date filters) and description filter

then straight table has to show as per the selection of the three filters of description and primary compare date filter1 and primary compare date filter2 in order to make the comparison in the column wise

how to do these three requirements, pls provide ur solution in the qvw file

Re: Comparing the week wise data base don the filter

senpradip007 — Wed, 02 Aug 2017 10:59:44 GMT

Have a look at this.

Re: Comparing the week wise data base don the filter

Anil_Babu_Samineni — Wed, 02 Aug 2017 11:00:06 GMT

1) Requirement 1 done

2) Used Alternate States to achieve this

3) For this, I would ask you to create 2 variables and then call those 2 variables into two calendar objects. Then check from your object where you are done this

HTH

Anil

Re: Comparing the week wise data base don the filter

manoranjan_d — Wed, 02 Aug 2017 11:42:37 GMT

Hu sen,

when i select the description field then primary dates are not filtered out, i want to make filter as per the description selected.

Re: Comparing the week wise data base don the filter

manoranjan_d — Wed, 02 Aug 2017 11:47:45 GMT

Hi anil

requirement is not achieved since when we assign alternate state to the primary date nothing is happening when we select the description filed

Re: Comparing the week wise data base don the filter

Anil_Babu_Samineni — Wed, 02 Aug 2017 11:50:22 GMT

May be i am not following you

Re: Comparing the week wise data base don the filter

senpradip007 — Wed, 02 Aug 2017 11:52:46 GMT

Look at this.