Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Day wise Budget logic help.

Hi

I have the following table

Budget:

load * inline

[

Plant,Month ,Value,Day

P1,Jan,100,MO

P1,Jan,105,TU

P1,Jan,108,WE

P1,Jan,95,TH

P1,Jan,74,FR

P1,Jan,120,SA

P1,Jan,130,SU

];

now want the data, Same day of the Month has same Budget.

ex:- Budget of all Mondays of Jan should be 100, Budget of all Tuesdays of Jan should be 105 and so on.

Please help me out to right the same logic.


Thanks,

Lalit Kumar

1 Reply
Highlighted

Re: Day wise Budget logic help.

Connect your Budget Table to the Master calendar on Month and Day field... Have you tried this already?