Hello

I am trying to do some set analysis within a table,  I want to take range from the start period to period 9

The variable for start period is vStartPeriod_CY (eg 201900), and I am trying to get to the range  201900 to 201909 into the set analysis

For  example I tried the below but it didnt seem to work.  Can you see what i am doing wrong ?

Many thanks Paul

sum({$<period = {">=$(vStartPeriod_CY)<=$(=vStartPeriod_CY + 09)"},
costc = {681,685},
bud2_line = {"OFFICE COSTS"},
Datasource = {'Actual'}
>} $(vCurrency)) * Infra%

Hi,

I am fairly new to QS and not able to arrive at a sol for below issue.

I have my data like below with dimensions being Portfolio, reporting date and  segment.

I select a Portfolio(H/S/….) and a reporting date ,lets say I select aug19 and S

I should see graph and data as below

and a combo graph plotting the both volume and change. (The %change formula in the example is probably not correct. I meant (previous value -current value)/previousvalue.

Can some one pls help

Hi,

I'm using Qlik Sense' REST API connector to pull data from HubSpot CRM. HubSpot documentation reads:

"Get all of the deals in a portal.  Returns a paginated set of deals.

In addition to the list of deals, each request will also return two values, offset and hasMore. If hasMore is true, you'll need to make another request, using the offset to get the next page of deal records." (from Get all deals‌ )

Default records returned is 100.

I need help configuring the 'pagination type' settings in Qlik Sense. Please help.

Hi Geeks,

This might be simple but I am breaking my head. I want the calculation that is done on the chart to be implemented in the script.

Open Inventory = Previous Month Closing Inventory(Expression : Above(Closing Inventory))

Closing Inventory = Open Inventory + In Sales - Out Sales

This is easy in the chart as I can use the column labels and get it done but seems tricky in the script.

Reason behind needed in the script: If nothing is selected, all good. But if I select a month, the calculation starts for the selected month. Open Inventory can't take the previous month Closing Inventory. So, if it is done in the script, everything will be pre-calculated.

I tried to be detail to my best . Let me know if any questions and thanks in advance.

-Naresh

Hello dear experts,
I have a field called Fecha as a date, i'm trying evaluate it with a rate of dates depending of the value which evaluating Date field, once i  try to load data the next error comes(Attached image).

if(Fecha<Date(30/01/2015,'DD/MM/YYYY'),
if(PM < PE15,1,0),
if(Fecha>= Date(06/01/2016,'DD/MM/YYYY'),
if(PM < PE16,1,0),
if(Fecha<= Date(10/05/2016,'DD/MM/YYYY'),
if(PM < PE161,1,0),
if(Fecha<= Date(17/11/2017,'DD/MM/YYYY'),
if(PM < PE17,1,0),
if(Fecha<= Date(29/04/2019,'DD/MM/YYYY'),
if(PM < PE,1,0)
)
)
)
)
) as Sub_PE

Thanks for help.

Regards.

Hi Team,

Filters not giving proper results.

If i filter for FY20 and Sep. PO count should be 152 and Requestor count should be 57

instead of PO count :144 and  Requestor count :53.

Can you please help?

Regards,

Savithri

Can't seem to figure this out. I have weekly (Friday) snapshot data on over 500 Projects with a Status field. My data is one .xlsx file that I keep concatenating to every week. My data spans all of 2019 to date (1/24/20).  

There are over 15 statuses, but I am trying to count how many projects have switched to Complete status in 2020. There are currently 42 projects that have a Complete status, but most of them have become Complete in 2019. 

How can I count when Status field changes to Complete (from any other status)? Should/can I do this at chart level, or in load script?

Sample data of one project: (altered for simplicity)

That project should be in my count, since it became Complete on 1/10/2020.  This project should NOT be counted....

.....Since it became Complete in 2019.

Thank you!!

Hi all,

I am trying to understand why this model does not work. I have two fact tables plus multiple dimensions (see image below). 

Why i have this circular references when having unique keys?

Of course I could avoid that by concatenating these tables, but I need to understand why in Qlik having tow fact tables linked to the same dimension cause troubles.

Thank you in advance,