topic Re: Need Help?? in QlikView

Need Help??

paulwalker — Wed, 18 Mar 2015 17:35:56 GMT

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.........

buzzy996 — Wed, 18 Mar 2015 17:42:33 GMT

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

Wed, 18 Mar 2015 17:45:26 GMT

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

Thanks

Anonymous — Wed, 18 Mar 2015 18:39:16 GMT

You can try trigger

Sheet Propieties-->OnActivateSheet