Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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.

Quarter.PNG

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

Default Week Data.PNG

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

4 Replies
Kushal_Chawda

reddys310‌ can help you

Gysbert_Wassenaar

See attached qvf.


talk is cheap, supply exceeds demand
reddy-s
Master II
Master II

Very helpful reply Gysbert. This should solve the issue.

Not applicable
Author

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.