topic Twisted Scenario in QlikView Need Help !!!!!! in QlikView

Twisted Scenario in QlikView Need Help !!!!!!

arsal_90 — Tue, 19 May 2015 13:44:08 GMT

Hi All,

Recently i am facing a twisted scenario which i am unable to resolve now i need you guys help. Please see the scenario with data in attachment.

Thanks & Regards,

Muhammad

Re: Twisted Scenario in QlikView Need Help !!!!!!

giakoum — Tue, 19 May 2015 14:59:30 GMT

is it always the start of the month date that is selected? What if you select 15-05-2015? What do you want to see then?

Slowly changing dimensions could be a solution here. or interval match if you have fixed time frames

Re: Twisted Scenario in QlikView Need Help !!!!!!

awhitfield — Tue, 19 May 2015 14:59:57 GMT

Hi Muhammad,

sound like ad hoc reporting may help, see the attached

https://community.qlik.com/blogs/qlikviewdesignblog/2014/01/31/customizable-straight-table

Andy

Re: Twisted Scenario in QlikView Need Help !!!!!!

arsal_90 — Tue, 19 May 2015 15:07:42 GMT

Not necessarily it can be any dates. For example if user select 05/14/2015 then its shows all quantity before and equal to that date. And if users select multiple dates. For example if he select 05/14/2015, 05/15/2015 and 05/18/2015. The result should be same as specified in the attached excel sheet.

Re: Twisted Scenario in QlikView Need Help !!!!!!

arsal_90 — Tue, 19 May 2015 15:12:21 GMT

Hi Andrew

it's not the ad hoc reporting. What i want is below:

For example if user select 05/14/2015 then its shows all quantity before and equal to that date. And if users select multiple dates. For example if he select 05/14/2015, 05/15/2015 and 05/18/2015. The result should be same as specified in the attached excel sheet. Means if i select multiple dates like above so for this date 05/14/2015 it will sum up all the quantity till that date and for 05/15/2015 it will sum up all the quantity between 05/14/2015-05/15/2015 and for 05/18/2015 it will sum up all the quantity from 05/16/2015 to 05/18/2015. Please see the attachment.

Thanks

Re: Twisted Scenario in QlikView Need Help !!!!!!

giakoum — Tue, 19 May 2015 15:13:15 GMT

Then you need slowly changing dimensions in order to specify every possible combination. Not o very good idea if you have large data sets

Re: Twisted Scenario in QlikView Need Help !!!!!!

arsal_90 — Tue, 19 May 2015 15:26:25 GMT

Hi Ioannis,

We used slowly changing dimension in order to cater if there is change in Dimension. For example Sales person designation is Sales Executive on 1/1/2015 but on 3/1/2015 sales person designation changed to junior sales executive and further on 8/1/2015 his designation again changed to Senior Sales Executive. So slowly changing dimension cater this scenario. My scenario is different please see my comments and attachment.

Re: Twisted Scenario in QlikView Need Help !!!!!!

arsal_90 — Tue, 19 May 2015 15:43:55 GMT

MRKachhiaIMP‌ Sir need your help

Twisted Scenario in QlikView Need Help !!!!!!‌

Re: Twisted Scenario in QlikView Need Help !!!!!!

arsal_90 — Tue, 19 May 2015 16:29:35 GMT

Please help me out guys

Robert_Mika‌

gwassenaar‌

Your help would be highly obliged.

Thanks

Re: Twisted Scenario in QlikView Need Help !!!!!!

arsal_90 — Tue, 19 May 2015 16:51:36 GMT

Hi All Community members,

If any one have faced this scenario. Please help us out.

Thanks

Re: Twisted Scenario in QlikView Need Help !!!!!!

rwunderlich — Tue, 19 May 2015 19:07:10 GMT

1. Create an AsOf Table for your Date in the script.

2. Create a Pivot table with Product as Dimension and AsOfDate as a horizontal dimension.

3. For expression:

sum(Sales) -alt(Before(sum(Sales)),0)

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Twisted Scenario in QlikView Need Help !!!!!!

arsal_90 — Tue, 19 May 2015 21:02:30 GMT

Hi Rob,

Thanks alot for your response. Actually i did as you said and created a as of table on my data but i don't know some thing is wrong i want a favor can you please make a qvw on my attached data file.

Your help would be highly obliged.

Thanks & Regards,

Arsalan

Re: Twisted Scenario in QlikView Need Help !!!!!!

rwunderlich — Tue, 19 May 2015 22:23:27 GMT

Please upload your QVW and maybe someone can take a look.

-Rob

Re: Twisted Scenario in QlikView Need Help !!!!!!

jagan — Wed, 20 May 2015 03:57:59 GMT

Hi,

Is there any restriction on date selection? Like 1 date / 3 dates etc. What if the user selects 2 dates, 3 dates, 5 dates etc.

If it is 1 or 3 dates selection then it is possible otherwise it would be very difficult to handle.

Regards,

Jagan.

Re: Twisted Scenario in QlikView Need Help !!!!!!

arsal_90 — Wed, 20 May 2015 07:56:10 GMT

Hi Jagan,

Thanks for your reply. There is no restriction on dates user can select 1 date and select as many dates as he want.

Re: Twisted Scenario in QlikView Need Help !!!!!!

arsal_90 — Wed, 20 May 2015 07:59:26 GMT

Hi Rob,

Due to data security i can't upload my qvw but i upload the demy data for you guys. if you can create a qvw from the data that's so great of you. And in excel 2nd tab i also mentioned the desired result.

Re: Twisted Scenario in QlikView Need Help !!!!!!

arsal_90 — Wed, 20 May 2015 08:02:02 GMT

Hi Jagan,

Is there any solution to cater this problem. I really appreciate your help.

Thanks & Regards,

Arsalan

Re: Twisted Scenario in QlikView Need Help !!!!!!

jagan — Wed, 20 May 2015 08:39:47 GMT

HI,

What if user selects 4 dates, 5 dates, 6 dates, etc. there should be some logic.

Regards,

Jagan.

Re: Twisted Scenario in QlikView Need Help !!!!!!

arsal_90 — Wed, 20 May 2015 08:47:41 GMT

Hi Jagan,

Thanks for your reply.

But user selection is not limited to 4 or 5 dates. And that's the problem that i am facing. If user selection restricted to 4 or 5 dates then i used Input box to take date as input and then evaluate the expression. Please share your idea.

Thanks & Regards,

Arsalan

Re: Twisted Scenario in QlikView Need Help !!!!!!

arsal_90 — Wed, 20 May 2015 10:34:42 GMT

Need help Community members !!!!!!

Thanks,

Arsalan