Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have three fields in sheet 3 as CDay, CMonth, CYear
and three fields in sheet 4 as Day, Month, Year
If I select any of the 3 fields in sheet 3 when I move to sheet 4 the same values must be selected in the sheet 4 for the other fields.
like example given below:
can anyone help me in this?
Regards,
Yoganantha Prakash G P
The default behavior in Qlik should keep selections in listboxes across tabs if they are the same fields.
Looking at your screens, it appears these are not the same fields but you want the selections in one set of fields to be mirrored in a different set of fields. I'm assuming you have your own reasons for this.
There are a couple of ways to do this:
1) Use a canonical date to make 1 selectable date across tabs.
To try that see Canonical Date
2) Use triggers to select the same values in the other fields.
So the trigger action would be select in field. And the search string would be
='('&Concat(Distinct CMonth,'|')&')'
You would have to set that up for each field. You could have the triggers run at each field selection or when you switch tabs.
You may also want to Clear Field first too.
Can you share your qvw doc as a sample?
I cannot share it sunny
This will come default in Qlikview. Do you have any action like Clear All in Sheet4??
No anil,
Three fields in sheet 3 and three fields in sheet 4 are not same.
Okay
Haha, Looks like you just taken same fields and rename it. Any how, You don't require to share real data. Why can't create sample data which you are showing screen shot. I don't think so that application has any secure data. Will you?
The default behavior in Qlik should keep selections in listboxes across tabs if they are the same fields.
Looking at your screens, it appears these are not the same fields but you want the selections in one set of fields to be mirrored in a different set of fields. I'm assuming you have your own reasons for this.
There are a couple of ways to do this:
1) Use a canonical date to make 1 selectable date across tabs.
To try that see Canonical Date
2) Use triggers to select the same values in the other fields.
So the trigger action would be select in field. And the search string would be
='('&Concat(Distinct CMonth,'|')&')'
You would have to set that up for each field. You could have the triggers run at each field selection or when you switch tabs.
You may also want to Clear Field first too.
Wallo,
Its working thanks