Showing data with Zero values while using set analysis

[sridhar_sigired]

Hi,

I have data whereas on few dates transactions are not there. I want to show table with zero values where data is missing.

I can able to show them using simple join with calendar. However i have to create different charts using set analysis but i cannot able to show date with zero values.

I believe there is small change required in set analysis. But i can not able to get. Please find the attached qvw and excel data to understand more.

Please help me to achieve this. Thanks.

Sridhar

[sunny_talwar · Accepted solution]

May be this:

Sum({<Type={'A'}>}Amount) + Avg({1<Month = p(Month)>} 0)

[sridhar_sigired]

Thanks Sunny, giving correct results. However i am not aware how it works "+ Avg({1<Month = p(Month)>} 0)"

and any drawback using this?

[sunny_talwar]

Don't think there are any drawbacks. Have you found any? I might not be aware of all the selections you might be planning to make, so can't really say

[sridhar_sigired]

Yes, you are true.. i will make selection boxes fields duplicate to avoid confusion for user.

Thanks sunny.  I will analyze how is working to get this result.