Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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.
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
Then you need slowly changing dimensions in order to specify every possible combination. Not o very good idea if you have large data sets
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.
MRKachhiaIMP Sir need your help
Hi All Community members,
If any one have faced this scenario. Please help us out.
Thanks