topic Re: Showing data with Zero values while using set analysis in QlikView

Showing data with Zero values while using set analysis

sridhar_sigired — Tue, 16 Aug 2016 10:52:42 GMT

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

Re: Showing data with Zero values while using set analysis

sunny_talwar — Tue, 16 Aug 2016 10:59:34 GMT

May be this:

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

Re: Showing data with Zero values while using set analysis

sridhar_sigired — Tue, 16 Aug 2016 11:19:13 GMT

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

and any drawback using this?

Re: Showing data with Zero values while using set analysis

sunny_talwar — Tue, 16 Aug 2016 11:22:31 GMT

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

Re: Showing data with Zero values while using set analysis

sridhar_sigired — Tue, 16 Aug 2016 11:33:53 GMT

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.