Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
reddys310 can help you
See attached qvf.
Very helpful reply Gysbert. This should solve the issue.
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.