Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
gautik92
Specialist III
Specialist III

Selection

I have two different Calendars

if i select some dates in first calendar it should affect in second calendar.

i tried using trigger select in field but it is selecting single record if we select multiple dates it is not working.

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

Try below expression,

=If(GetSelectedCount(DateId)>0,'(' & Concat(DateId,'|') &')')

View solution in original post

7 Replies
avinashelite

how the fields are connected in the model?? whats the expression your writing in the trigger expression ?

gautik92
Specialist III
Specialist III
Author

Select in field

Fieldname

=GetfieldSelections(Fieldname)

PrashantSangle

Hi,

check Canonical Date

and

Master Calendar

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
gautik92
Specialist III
Specialist III
Author

I don want to create Canonical Calendar i Want to use triggers

tamilarasu
Champion
Champion

Try below expression,

=If(GetSelectedCount(DateId)>0,'(' & Concat(DateId,'|') &')')

jonathandienst
Partner - Champion III
Partner - Champion III

Firstly, I would make the same suggestion as max dreamer, or make use of globally evaluated variables (ones with an = sign in the definition), rather than triggers. But if you insist, you will need to provide more information about what you are trying to achieve, as well as details about what you tried, what you expected, and what you actually got - "not working" is not a diagnosis.

Best of all would be to upload a small sample qvw that illustrates the problem.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
SunilChauhan
Champion
Champion

You should generate a common calender based on those two  and link the two calender with them

Sunil Chauhan