Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I have Date field and amount, need to create week fields with ["start date" of week - "last date" of week] as field
and then WoW % analysis for the same. I am able to do it in backend but that is knid of static weeks
is there any way to do it in Front end , user selcts a date then dynamically it should change week and then wow%
Any suggestions are welcome.
Regards,
Rajni Batra
Rajni,
please look here:
Let me know if you found some ideas.
regards
Darek
Hi Dariusz ,
Thanks for the link but this is again something in scripting i want this to be in front end , directly in pivot.
Is it possible??
Regards,
Rajni
Try using calculated dimension:
=WeekStart(Date)&'-'&WeekEnd(Date)
Hi Rajni,
Do same implementation in the front end that you did in the backend and use the variables for that. I think it will done in front end also.
Regards
Hi Anand,
i tried to show prev week value in front of curr week but couldn't make it. do you have any example of that.
I am not sure what is your exact expectation. Do you want to let user
select first day of week? And then compare weeks for example from saturday
to friday?
23-04-2014 07:57 użytkownik "Rajni Batra" <qcwebmaster@qlik.com>
napisał:
Qlik Community <http://community.qlik.com/> WoW% in UI
reply from Rajni Batra<http://community.qlik.com/people/rajni.batra?et=watches.email.thread>in *App
Development* - View the full discussion<http://community.qlik.com/message/513890?et=watches.email.thread#513890>
Or maybe always monday is first day of the week, but you like to give your user possibility to select week, which will be compared with another weeks?
regards
Darek
yes right .. and then wow variance based on user selection.
which is again have 2 dimensions.
maybe you like something like this:
regards
Darek