- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Set analysis not working in Server
hi,
My set analysis works in local computer application. however when deploy into web access. that particular chart has error" No data to display".
Other charts using the same data are working fine
would need some advice on how to revise this set analysis, so server 11 can interpret it.
the purpose is to show last 6 months only. Dimension limit will not do that job.
MTK_MONTH_YEAR={">$(=date(addmonths(maxstring(MTK_MONTH_YEAR),-6),'MMM-YY')) <=$(=date(maxstring(MTK_MONTH_YEAR),'MMM-YY'))"}
this is the potion that is causing the issue..
My desktop application is Qlikview NOV 2017 SR3
The server should be 11.
MTK_MONTH_YEAR
Jul-17
Aug-17
Sep-17
Oct-17
Nov-17
Dec-17
Jan-18
Feb-18
Mar-18
Apr-18
May-18
- « Previous Replies
-
- 1
- 2
- Next Replies »
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try below
MTK_MONTH_YEAR={">$(=date(addmonths(date#(maxstring(MTK_MONTH_YEAR),'MMM-YY'),-6),'MMM-YY')) <=$(=date(date#(maxstring(MTK_MONTH_YEAR),'MMM-YY'),'MMM-YY'))"}
Regards,
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Thanks for reply. But it does not work..
It is still showing 'No Data to display'
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
do you have data for that period on production? is there any section access over there?
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
can you let me know your complete expression. This happens when you use some if conditions or any other additional conditions in your chart which is not having any value for this 6 months period.
Thanks,
Shan S
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hello
just a question
what is the type of MTK_MONTH_YEAR ?
if it is consiedered as string, maxstring() returns Sep-17 ....
is it what you want ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi,
this is the full expression it is rather confusing.
Round(
(
(Sum({$<MTK_MONTH_YEAR={">$(=date(addmonths(maxstring(MTK_MONTH_YEAR),-6),'MMM-YY')) <=$(=date(maxstring(MTK_MONTH_YEAR),'MMM-YY'))"},MTK_YEAR=, MTK_QTR=, MTK_MONTH=, MTK_WEEK=, MTK_DATE=, DATASOURCE_ID={'DAILY ALLOCATION'},METRIC_LEVEL2_ID-={'Start-Outstanding','Volume In','Incomplete'}>} EFFORT ))
/
(Sum({$<MTK_MONTH_YEAR={">$(=date(addmonths(maxstring(MTK_MONTH_YEAR),-6),'MMM-YY')) <=$(=date(maxstring(MTK_MONTH_YEAR),'MMM-YY'))"},MTK_YEAR=, MTK_QTR=, MTK_MONTH=, MTK_WEEK=, MTK_DATE=,DATASOURCE_ID={'ATTENDANCE'},METRIC_ID={'Mtk Hours Worked'}>} EFFORT )
-sum({$<MTK_MONTH_YEAR={">$(=date(addmonths(maxstring(MTK_MONTH_YEAR),-6),'MMM-YY')) <=$(=date(maxstring(MTK_MONTH_YEAR),'MMM-YY'))"},MTK_YEAR=, MTK_QTR=, MTK_MONTH=, MTK_WEEK=, MTK_DATE=,DATASOURCE_ID={'ATTENDANCE'},METRIC_ID={'Loan'}>}EFFORT))
)
,0.001)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi,
MTK_Month_year is Date with format of MMM-YY
on my local application, i used MAX().. but in the server i have to use MAXSTRING...
i learnt this as other chart with much simpler set analysis have this issue too.. after i change MAX to MAX string the charts works.
however for this particular expression.. the issue persist. the error is "No Data to Display"
MTK_MONTH_YEAR={">$(=date(addmonths(maxstring(MTK_MONTH_YEAR),-6),'MMM-YY')) <=$(=date(maxstring(MTK_MONTH_YEAR),'MMM-YY'))"}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
that indicates that your set analysis results in no data according to the selection
try to create text boxes with each formula to determine the value they return
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
looks like you have issue in date interpreting.
As per my understanding here MTK_MONTH_YEAR is interpreting as string that's why max() is not working. If it is in string then you can not use it for range period that's why >= and <= is not working.
modify your script where you have written MTK_MONTH_YEAR field
modify it as
date(date#(MTK_MONTH_YEAR,'MMM-YY'),'MMM-YY') as MTK_MONTH_YEAR
then use same use set analysis which you use in your local machine.
Regards,
Prashant Sangle
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
- « Previous Replies
-
- 1
- 2
- Next Replies »