Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
mhmmd_srf
Creator II
Creator II

Repeatation of Planned Sales

Hi All,

I have Actual and Planned Sales. Actual is on Date Level and Planned is on Month Level.

But in my Table I want to show Month level Planned Sales repeating to each day.

In the above screen shot. Monthly Planned Sales for 2016 and Month =3 is 1701335.95.

I want this value to be repeating in each Day.

I am attaching my qvw file.

Please help.

Thanks,

Sarif

1 Solution

Accepted Solutions
qlikdeez
Specialist
Specialist

try sum({<DateTransaction=>}total [Planned Sales])

View solution in original post

3 Replies
qlikdeez
Specialist
Specialist

try sum(total [Planned Sales])

mhmmd_srf
Creator II
Creator II
Author

Yes Sir,

It is repeating now. But the problem is If I select any Date, then it is showing different value.

I want this to be fixed for any date selection from THAT PARTICULAR MONTH.

Please help.

Thanks,

Sarif

qlikdeez
Specialist
Specialist

try sum({<DateTransaction=>}total [Planned Sales])

View solution in original post