Dear, 

I am creating a nprinting ppt report base on a qlikview document. I've included page <Site_Cockpit> options in PPT  Qlik Nprinting, it returns different sites in the PPT output slide but the slides are not filtered.  For my different tests, I have the following cases.

• The output slide for each site shows the total results for both objects. ( Filters on site not applied).
• Or sometimes, for each output slide by site, the top graph is filtered but the below graph does not filter.
• Or sometimes, the below graph is filtered but the top graph is not filtered.

The filters do work on the report itself. so I wonder what I am doing wrong for this not to work as expected.

Thank you.

Hello ,

I am new to Qlik and Qlik sense ,  I am stucking in sum the value based on another value in the dimension(category)

hope someone could help me out here. thanks!

I have a table on the left , and I want to sum the value where year_week = snapshot_week per snapshot,

which means I would like to get on snapshot_week 202112 = 100 ,  snapshot 202113 =101, snapshot 202114 = 200.

and also sum value where year_week < snapshot_week per snapshot.

meaning Snapshot 202112 = 200 ,  snapshot 202113 =303, snapshot 202114 = 800.

and I used   sum({<year_week={"<(=Min(Snapshot_week))"}>}Sales) , it does not work.

what is the difference when I put a $(=Min(Snapshot_week) ?

Hi there,

I have a dataset like below coming from file :

FACILITY = facility_name

D1:

I need to generate unique key by joinng D1 with D2 which is the extract from view:

D2:

My requirement is my script:

I have to generate the field

Load

"facility_identifier" & '-' & "VISIT_ID" as Uniquekey,
*
Resident [table];

So, I did something like below script :

[Care]:
LOAD
FACILITY,
If(FACILITY like '*Hospital1*', 'Hospital1',
If(FACILITY like '*Hospital2*', 'Hospital2',
If(FACILITY like '*Hospital3*', 'Hospital3','FACILITY')))))) as facility_name,

VISIT_ID
FROM [lib://AttachedFiles/Data.xlsx]
;

Unqualify *;

left join ([Amber Care])
LOAD "facility_identifier" ,
facility_name
SQL SELECT *
FROM "view";

Unqualify *;

[Amber Care Final]:
Load "facility_identifier" & '-' & "VISIT_ID" as VISITID,
*
Resident [Amber Care];

Drop Table [Amber Care];

But getting more records after execution.

Regards

Hi All,

Below is my expression :  I want to restrict this value on month field selections but should work on YEAR selection. I tried restricting using MONTH= but it is not working

(((sum({<ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[ACTUAL COST])//,month([EXPENDITURE DATE]))
/
sum({<ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},baseline_flag={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[BUDGETED AMOUNT]))
*
sum({< ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[CONTRACTUAL AMOUNT]))
-
(sum({<ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[ACTUAL COST])))
/
((sum({<ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[ACTUAL COST])//,month([EXPENDITURE DATE]))
/
sum({<ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},baseline_flag={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[BUDGETED AMOUNT]))
*
sum({< ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[CONTRACTUAL AMOUNT]))

Please help.

Thank you.

I am using the Qlik API to grab the current selection in a field. There seems to be an "unofficial" limit of around 50 without showing "xx of xxx" in qSelected. Would appreciate it if anyone could confirm or provide a workaround. See screenshot below.

This is despite me having this in settings.ini:

Thanks in advance!

I have a request form our client to allow users to create line charts that will have year as the X-Axis and show the year values with proportional spacing that will accommodate missing year values.  For instance, if the user selects years of 2005 - 2010 plus  2017, and 2018, then the chart would show these years. with the correct spacing between the data points.  So between 2010 and 2017 data points, there would be space that is proportional to the missing years.  Excel will autogenerate the missing years when you create this type of line chart.  Can anyone tell me if this is possible with Qlik Sense? 

Thanks

Brian 

Hello experts

I need your help. I need the current month and the ongoing month of a selected year. Example: Today is 05/08/2021

Current formula only gives May. I need May until December of 2021:

Month(today([Delivery Date] + [Days]))

Any ideas?

Many thanks

tom

I am trying to duplicate an App I've created, but have run into several issues when doing so.

1. It seems that in the duplicate App,  only sheets that are published and approved get copied. An inconvenience, but workable.

2. Master Visualizations appear to not carry over to the Duplicated App. This is a show stopper- I have created several master visualizations, and then use them in custom objects. Once I open the duplicated App, they are all gone.  

Looking for guidance or insight.

Happy May everyone! Believe it or not, this month is our 12^th edition of Round of Applause! Even though it’s a cool name, we wanted an even cooler name for our featured members so from here on in we are going with High Five! This Community member has over 20K posts, received more than 8k likes, answered over 4K questions, and is a well-known leader in the Qlik Community. Today’s High Five goes to no other than Community MVP, Gysbert Wassenaar.

Gysbert joined the Qlik Community in September 2012. He had been visiting for a while, looking for answers to Qlik challenges he encountered in his job. He was already impressed by the quality of the answers he saw and by Community members who gave great solutions and advice. Gysbert was also impressed that Qlik employees participated actively. The day he decided to join the Community was when he saw a question from a community member and thought: "Hey, I think I know the answer to that." It was then he started participating, and he became hooked! Gysbert said he’s never learned so much so quickly about a product. Every question posted was another opportunity to expand his knowledge and Qlik skills.  Three months later, he was a Top 5 contributor. He recalls passing Stefan Wühl as top contributor about a year after he joined. The feedback from other community members, and especially from Qlik Community legends like Deepak Vadithala,  Stefan Wühl, John Witherspoon, Miguel Angel Baeyens, Henric Cronström,  Rob Wunderlich, Marcus Sommer and so many more, was awesome and a big motivating factor to keep coming back to the Qlik Community.

In his personal life, Gysbert is very fortunate to be living in a small beautiful medieval city in the Netherlands. He likes reading, taking walks in the countryside, learning about new technologies, and learning new tricks he can apply in his job.

Let’s give a big “High Five” to Gysbert with a like and a comment to show how much we appreciate his collaboration in the Qlik Community. @Gysbert_Wassenaar @Melissa_Potvin @marcus_sommer @rwunderlich @Henric_Cronström@Miguel_Angel_Baeyens @swuehl @johnw @IAMDV