Bar Chart showing wrong info,How to Create Master Calendar with two date fields?

[#1]

Hi Folks,

I am new to QLIK SENSE.

Please find the below snippet as i am facing some disturbance with the date fields..

Please find the below attached sample data and qvf file.

In the above one Close - Jan (206) , here it was showing wrong data.

This is Default Data i.e., latest 10 weeks need to show.

Here i need to create one more measure..

NetOpen - If i select a month of Jan'16

NetOpen(Jan'16)=Open(Dec'15)+Open(Jan'16)-Close(Jan'16) --> Formula

Can any one help with this..

sub2u444‌

[Kushal_Chawda]

reddys310‌ can help you

[Gysbert_Wassenaar]

See attached qvf.

[reddy-s]

Very helpful reply Gysbert. This should solve the issue.

[#5]

Hi Gysbert,

Thanks for your reply.

Sorry to late response. I am sorry with Previous one, Because of no explanation.

If i select "OpenDate" as Jan16 and "CloseDate" as Null -> Open Count

If i check in "CloseDate" as Jan16 -> Close Count

Can You change the Expression..

** One more measure to add as "NetOpen"

Ex:- If i select a "Q1-2016"

Jan16 data should be show as

NetOpen=PreviousMonthOpenCount+CurrentMonthOpenCount-CurrentMonthCloseCount

Ex :- NetOpen(Jan16)=Dec15(OpenCnt)+Jan16(OpenCnt)-Jan16(CloseCnt)

I feel its little bit tricky, becz i am new to Qlik Sense.

Thanks in advance Gysbert.