topic Re: Bar Chart showing wrong info,How to Create Master Calendar with two date fields? in QlikView

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

Tue, 12 Apr 2016 03:03:37 GMT

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..

Kushal_Chawda — Tue, 12 Apr 2016 05:36:16 GMT

reddys310‌ can help you

Gysbert_Wassenaar — Tue, 12 Apr 2016 05:55:42 GMT

See attached qvf.

reddy-s — Tue, 12 Apr 2016 09:29:43 GMT

Very helpful reply Gysbert. This should solve the issue.

Tue, 12 Apr 2016 11:41:18 GMT

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.