topic Re: WoW% in UI in QlikView

WoW% in UI

rajni_batra — Tue, 22 Apr 2014 11:19:40 GMT

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

Re: WoW% in UI

Tue, 22 Apr 2014 12:10:44 GMT

Rajni,

please look here:

compare set of rolling months

Let me know if you found some ideas.

regards

Darek

Re: WoW% in UI

rajni_batra — Wed, 23 Apr 2014 05:57:02 GMT

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

Re: WoW% in UI

tresB — Wed, 23 Apr 2014 06:04:11 GMT

Try using calculated dimension:

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

Re: WoW% in UI

its_anandrjs — Wed, 23 Apr 2014 06:06:55 GMT

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

Re: WoW% in UI

rajni_batra — Wed, 23 Apr 2014 06:24:17 GMT

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.

Re: WoW% in UI

Wed, 23 Apr 2014 06:42:06 GMT

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>

Re: WoW% in UI

Wed, 23 Apr 2014 07:27:41 GMT

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

Re: WoW% in UI

rajni_batra — Wed, 23 Apr 2014 07:42:23 GMT

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

which is again have 2 dimensions.

Re: Re: WoW% in UI

Wed, 23 Apr 2014 08:25:24 GMT

maybe you like something like this:

regards

Darek

Re: WoW% in UI

Wed, 23 Apr 2014 09:22:08 GMT

Rajni,

let me know if my example helps you resolving your problem.

regards

Darek