Hello, 

I have actually a daily application, every day data change,  i want to freeze data per week and per month. 

My solution is to create one application for week (execution once a week) and one for month (execution once a month) ,  but for maintenance it's not great. 

Is there a solution by keeping a single application ? 

Best regards

Thank you 

Dear Community

I have a question with regards to a count if:

I need to count unique customer ID based on a set analysis: 

Rangesum(Above(sum({<Time_Groups_Total={'Month Folder'},Sub_Category={'Drinks'}>}if(Year2Date(Trans_Month,0,if(MONTH(vMaxMonth)>11,1,MONTH(vMaxMonth)+1),vMaxMonth),$(vMeasure))/
sum(total{<Time_Groups_Total={'Month Folder'},Sub_Category={'Drinks'}>}if(Year2Date(Trans_Month,0,if(MONTH(vMaxMonth)>11,1,MONTH(vMaxMonth)+1),vMaxMonth),$(vMeasure)))), 0, rowno()))

The above should be counting customers ID where the set analysis is smaller than 80%

I have placed this set analysis in a Variable .

Please advise

Hello everyone,

Qlik Catalog is a modern enterprise data management solution that simplifies and accelerates the curation, preparation, and delivery of trusted, actionable data to business users across the enterprise.

hello guys, what's up,
I need help with how I can compile a new “QlikDeploymentFramework.exe” because I made a change to the standard qvs “12.Index.qvs” and every time I create a container, “QlikDeploymentFramework.exe” undoes my changes in all existing containers.
This also occurs in my “.gitignore” file because I do not enable the “Instals Qvc Lib” option and with that the “.gitignore” is also mortified for what is compiled inside my “QlikDeploymentFramework.exe” version 1.7.4, this mess my whole environment.
So I would like to make changes to these two files and complicate a new “QlikDeploymentFramework.exe”, how is that possible?
Thank you in advance.

Problem:

I want to create a single KPI with the count of the dimension SDTL_REFERENZ_NR if the aggr() count of two dimensions (SSL_TEIL_ID_NO_ZZZZ, EBEF_SSL_ID) is greater than 3.

What I have:

count(
	if(
      	aggr(count({<
                    FALL_REFERENZNUMMER = {""},
		     >} distinct SDTL_REFERENZ_NR), SSL_TEIL_ID_NO_ZZZZ, EBEF_SSL_ID) >= 3,
        SDTL_REFERENZ_NR))

The problem is, this funtion gives me the count of aggr() groups which meet the if condition. But I want to count the number of the dimension SDTL_REFERENZ_NR which are in the aggregated group.

Example:

If I put the dimensions SSL_TEIL_ID_NO_ZZZZ and EBEF_SSL_ID in a table and add a count on SDTL_REFERENZ_NR it gives me the values I want to count in the table. This should give me "8" as the result of my KPI. My current KPI gives me "2" because there are 2 aggregated rows.

Hello,

i am trying to use the input variable in qlik sense, and want to set the different values in a drop down menu.

but it is only working for 2 values, when i add the 3rd value it only works for the first 2.

any suggestions?

Hello we all know that we can use the function LCGV to connect to a container and generate variables for the path of the desired folder...
now we've been using QDF at my company for almost 2 years and the thing is that we cannot know which container connects to which container
is there a way to visualize or to generate kind of dependency list between containers?

things are becoming cumbersome and like spider web if I can say
kindly advise
@Michael_Tarallo 
@Magnus_Berg 
@Damian_Waldron 

Hi all,

Can I add a single measure for different columns at the beginning of the column.It should be unique for all the columns.

for eg:

In case of Sales column,I want to add Revenue Sales GP%(which is a single value) at the top along with label of Revenue Sales GP%.It should be placed between Jan 2021 value and the column name(where the arrow is)

For Jobs column,I want to add Revenue Jobs GP% at the top which is again a single value and so on.