Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rajni_batra
Specialist
Specialist

WoW% in UI

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

10 Replies
Not applicable

Rajni,

please look here:

compare set of rolling months

Let me know if you found some ideas.

regards

Darek

rajni_batra
Specialist
Specialist
Author

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

tresesco
MVP
MVP

Try using calculated dimension:

=WeekStart(Date)&'-'&WeekEnd(Date)

its_anandrjs

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

rajni_batra
Specialist
Specialist
Author

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.

Not applicable

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>

Not applicable

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

rajni_batra
Specialist
Specialist
Author

yes right .. and then wow variance based on user selection.

which is again have 2 dimensions.

Not applicable

maybe you like something like this:

regards

Darek