Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
manoranjan_d
Specialist
Specialist

Comparing the week wise data base don the filter

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

6 Replies
senpradip007
Specialist III
Specialist III

Have a look at this.

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
manoranjan_d
Specialist
Specialist
Author

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.

manoranjan_d
Specialist
Specialist
Author

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

Anil_Babu_Samineni

May be i am not following you

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
senpradip007
Specialist III
Specialist III

Look at this.