Welcome to Qlik Community

I have a set analysis formula counting Sales from “Germany” as follows:

(Count({<[Country]={‘Germany}>} Sales))

I would like to however only consider the uniques of a third column called “Submissions”. The current selection double counts Submissions.

How might I go about removing all duplicates of a third column / submissions column?

I have 3 tables Customers, Accounts and Transactions.  What is the best way to create a link table between them as I'm not to sure how to go about this with the load script. Hopefully this makes sense. Sample in excel was created

The specific links:

-SourcePartyType = 'C' & SourcePartyID = CustID

-DestPartyType = 'C' & DestPartyID = CustID

• However if the SourcePartyType ='A' & SourcePartyID = AcctID --> PrimaryAcctID = CustID. Same link for DestPartyType.

 Sometimes a transaction can be made by a combination of the 2. Eg customer made a deposit to an acct 

Any guidance would be great thanks

Hey All!

I need your help with the data set (as an example I put it in excel):

What I need is to fetch during of calculation for field "Purge" the fileds above calculated (for example cell D10).

Is there function in Qlik Sense which let me to do it? 

I know that above() works only in table/chart, but is there an option to do it in my script?

Gr

Imagine you have a data island table with two columns, e.g. "Metric" and "Function". The function column contains a syntactically correct formula per metric which calculates its result over the remaining tables of the data model. Then create a table object in the UI and have Metric as dimension and the expression "$(=[Function])" as measure column. The output is an empty measure column unless I select one of the metrics in the dimension columns, then Qlik Sense Enterprise SaaS shows the correct result for the chosen metric. How do I need to formulate the expression so that it calculates the results for all rows right away? An empty sample QVF using the data model generated by hitting CTRL-0-0 in the load editor is attached

Hello Qlik Community,

Using set analysis to try and see whether Population or CO2 Per capita is the real trigger for our current excessive level of CO2 output via a "What If" using Set analysis, possible values P() and AGGR and Linest_M in the script.

Attached video explaining the app and logic and also the QVW application.

What are your thoughts?

Kr,

Cheenu

Hello All,

I have below field where the data is commencing from 2010 till now. 

My requirement is i have to show the data only for current year in this filter pane i.e it should show the dates starting from jan 2021 till the maximum. I don't know how to restrict this in filter pane.

@Kushal_Chawda 

Can anyone please help ?

Thanks in advance

Where should I make a calendar table in ETL?

Following different examples I have observed people are creating it in Transformation Layer, but why , why not in Loading ?

Use of Link Table: 

Making LinkTable following two stages, first loading fields from Table 1 and concatenating with Table 2 and then making keys out of it and this Link Table is created in Loading , after some research I have come to know it saves RAM, if it is made in Transformation Extra Storage space would be consumed as it is loaded again in LinkTable.

Someone with sufficient knowledge on these topics according to best practices, please throw some light.