topic Re: Showing data as day wise but dimension should be week in QlikView

Showing data as day wise but dimension should be week

nizamsha — Tue, 17 Nov 2015 19:46:33 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 ! !

Finally if its not under stable completed week should contain last day data on that particular week and the current week data should be today date kindly help to resolve this one

Re: Showing data as day wise but dimension should be week

jolivares — Tue, 17 Nov 2015 20:02:23 GMT

This kind of problems can be solved using a simple set analysis. Try to create a simple QVW with your data post and then I can explain for you what to do in this case.

Re: Showing data as day wise but dimension should be week

nizamsha — Tue, 17 Nov 2015 20:10:05 GMT

Here is the App as you asked

Re: Showing data as day wise but dimension should be week

jolivares — Tue, 17 Nov 2015 20:14:02 GMT

I just take your expresion for Net and Current put the project_Name

=num(avg({$<RunRate={'Net Average Run Rate'}, Project_Name>}RunRate%),'#,##0.00%')

=num(Avg({$<RunRate={'CurrentM_Average'}, Project_Name>}RunRate%),'#,##0.00%')

Now no matter what project you choose, your expresion always show the whole result.

Check it..

Re: Showing data as day wise but dimension should be week

nizamsha — Tue, 17 Nov 2015 20:21:47 GMT

No you Wrongly understand the logic i will show the output what i want

with out project Selection i want this output

Week ,Net ,Gross

W1 ,14.71 ,8.65

W2 ,30.79 ,31.70

W3 ,40.40 ,33.72

when i click on project B i want this output

Week ,Net ,Gross

W1 ,15.00 ,9.00

W2 ,32.30 ,33.30

W3 ,40.40 ,35.00

if goes to tomorrow W3 Net and gross will change even if i select the project or not even select the project and keep on going based on date

others week data should be null

Re: Showing data as day wise but dimension should be week

nizamsha — Tue, 17 Nov 2015 20:54:36 GMT

i know through Aggr we can able to bring this one .but i am missing something while going for aggr i cant identify what i was missing

Re: Showing data as day wise but dimension should be week

anlonghi2 — Tue, 17 Nov 2015 22:24:57 GMT

Nizam,

with your excel data the average of 14th day is 29.64% not 30.79 %: do you confirm ?

Re: Showing data as day wise but dimension should be week

anlonghi2 — Tue, 17 Nov 2015 22:34:47 GMT

Hi Nizam,

please look at attached qvw and let me know

Best regards

Andrea

Re: Showing data as day wise but dimension should be week

nizamsha — Wed, 18 Nov 2015 03:52:26 GMT

Hi Anlonghi,

Most probably we are near to the answer the completed week should show the max of the day data for gross and net in that case net and gross is correct for w1 and w2 but when comes to w3 it should show the current day data that mean 18th acording to ur QVW 18 th data is Net 42.0 Gross 32.45 when comes to tomorrow it should show tomorrow data

Regards

Nizam

Re: Showing data as day wise but dimension should be week

nizamsha — Wed, 18 Nov 2015 03:57:59 GMT

Hi Anlonghi,

date 1 to 30 is for November (Always current Month)

and also i will date up to today date remaining week i wont show in that case w1,w2,w3 will have data when comes to w4 and w5 it will be null.

Regards

Nizam

Re: Showing data as day wise but dimension should be week

anlonghi2 — Wed, 18 Nov 2015 07:19:03 GMT

Hi Nizam,

attached version 3 of qvw.

Please let me know.

Regards

Andrea