showing day wise data on a week dimension

nizamsha — Tue, 17 Nov 2015 19:35:40 GMT

Hi All,

Kindly have a look at the excel file.i have day wise data its Based on the current month only

Here is the scenario Dimension should be week .and also i have 2 Expression 1st is the Net and 2nd is the Current its in the Column RunRate .

Net Run Rate Data we should consider till the end of month but when comes to current run rate it should show up to today only

if i am in the 5 th day of nov it should show the avg for both the project A and B but when i click on the single project it should show the single project and if i am on the 6th day i want to show the avg only for both project similarly if i click on single project it should show the 6th day in week one .but when comes to 8th day .in week one i should see the 7 th day data and in week 2 it should show 8th day data others week should be null and the week should be split by 7 days .w1 to w4 contain seven days each in week 5 remaining days ! !

Re: showing day wise data on a week dimension

anlonghi2 — Tue, 17 Nov 2015 20:42:56 GMT

Hi Nizam,

please look at attached qvw and let me know.

Best regards

Andrea

Re: showing day wise data on a week dimension

nizamsha — Tue, 17 Nov 2015 20:49:02 GMT

Thanks my Friend

please have a look at this thread i have given the output too in this thread . i want a same output and also

i attached the application too

Showing data as day wise but dimension should be week

topic Re: showing day wise data on a week dimension in QlikView

showing day wise data on a week dimension

Re: showing day wise data on a week dimension

Re: showing day wise data on a week dimension