Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

paulwalker
Contributor

Need Help??

HI Community,

I have one Application.. in that 3 sheets Daily report and another 3 sheets Monthly reports

total i have 6 sheets.

i have 2 different date fields, Suppose Date and Date1

if i am open my application i want show first 3 sheets based on Max(Date)

second 3 sheets based on Max(Date1)

Thanks in Advance.........

3 Replies
buzzy996
Honored Contributor II

Re: Need Help??

hey,what is ur question  here....

hopes,u want open

first 3 sheets based on Max(Date) ? yes u can do it by mapping with same field

second 3 sheets based on Max(Date1)? yes u can do it by mapping with same field

Not applicable

Re: Need Help??

You can use trigger "OnActivateSheet" to filter the data by Date or Date1.

Thanks

maverjannet
Valued Contributor

Re: Need Help??

You  can try  trigger

Sheet Propieties-->OnActivateSheet

sheet.PNG