1,079 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
47
views
Period over period line chart using qlik sense
I have a line chart where I have my order date on dimension and the total sales as a measure. When I choose for example date range as jan 8 to 14.which will give me the daily sales on line chart ...
0
votes
0
answers
59
views
Issue Migrating IntervalMatch() from QlikView to Qlik Sense — Only Field Names, No Data Returned
I'm migrating a QlikView app to Qlik Sense, and I'm running into an issue where a script using IntervalMatch() stops returning data in Qlik Sense, even though it works perfectly in QlikView.
✅ Context
...
2
votes
0
answers
46
views
How to embed Qlik cloud pivot table in Vue JS?
I have created an application which connects with Qlik cloud environment. The filter items already embedded using the below code
<qlik-embed
:id="embeddedObjectId"
ui="analytics/...
0
votes
1
answer
118
views
Qlik - Need help creating a calculated field that contains a sum of some of the values in another column
I have a data set that looks like this:
Column A
Column B
Column C
Q1
1743
382
Q1
1376
Q2
1599
419
Q2
1283
And my goal is to create a calculated field that takes the number in Column C and divides it ...
0
votes
0
answers
18
views
User creation - Unexpected user elevation after login
I am having an Issue with API User Permissions: Unexpected Elevation After Login
issue when adding users via API calls to our environment.
API Request:
POST https://<tenant>.uk.clickcloud.com/...
0
votes
1
answer
39
views
How to avoid the "Allow Macros" confirmation in QlikView 11 with NPrinting?
In my work environment, I use QlikView 11 along with NPrinting, which automatically sends reports to other users. However, I encounter an issue where certain reports use macros, and NPrinting stops ...
0
votes
1
answer
45
views
How can I calculate mean, standard deviation etc. over groups in QlikView?
I have a sheet with two columns (MONTH and NAME) and I can easily make a table of names by month, setting Dimension = MONTH and Expression = COUNT(NAME).
Now I want to calculate mean and standard ...
0
votes
1
answer
42
views
A calculated dimension that combines years (if the year is completed) and months (if the year is not completed)
I'm trying to create a calculated dimension in the diagram (not a script!), which will contain a combination of years and months:
if the data in the diagram, taking into account user filters, contains ...
-1
votes
1
answer
101
views
Equivalent Function between Qlik and PowerBI
I am doing migration report from Qlik to PowerBI.
I am wondering how to change this Qlik function into PowerBi.
=Num(Count(distinct {1 <[Type]-='Other',SaleDate=P(MasterCalenderDate)> } [...
0
votes
1
answer
86
views
How can I extract a Qlik app layout/structure as JSON directly from Qlik cloud?
What is the simplest way to get the structure/layout of my Qlik dashboards in the form JSON files in Qlik Cloud? So it should contain detailed informaions about visualizations & styles.
I can ...
0
votes
1
answer
175
views
Update QLIK Data Connection of type Amazon S3 with new IAM Access key and Secret Key using QLIK Rest API
I have a requirement to update QLIK Data connection of type Amazon S3 using QLIK API through an automated script.
We rotate our IAM access keys every 90 days. So, we have to update our QLIK Amazon S3 ...
2
votes
1
answer
181
views
Unable to get comma separated values in Qlik text box for a certain logic
I want a comma separated value in a qliksense text box.
Consider the following data
REGION|MARKET|METRIC|VALUE
ASP|INDIA|S1|1
ASP|CHINA|S1|0
ASP|INDIA|S2|0
ASP|CHINA|S2|1
ASP|HONGK|S1|1
EUR|UK|...
0
votes
1
answer
139
views
Compare the data sets coming from two set expression in Qliksense
I have a data set in the columns as follows:
Reporting Month
Object ID
Flag
Flag column can have values as 1 or 0. Reporting Month column has data for May & June.
I want the list of all Object ID ...
0
votes
1
answer
444
views
Qlik left join to the same table - how it works in SQL?
I have such a tranformation in Qlik
abc:
SELECT distinct
AA.ACCOUNT_ID AS ACCOUNT_ID_AA,
AA.ID AS ID_AA,
AA.F_a AS F_a_AA,
AA.F_b ...
0
votes
1
answer
616
views
Qlikview to SQL conversion
Can anyone help to convert the below qlikview code to snowflake SQL?
I just started with qlikview to snowflake migration and have very minimal knowledge on qlikview so need help on how applymap works ...