Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I know this girl since 2019 from a part time job i did on and off. Her name is Sarah and she has the most beautiful smile I have ever seen in my life. I always like talking to her but she sees me nothing more than a friend. And of cause 2020 happened so I didn't have any communication with her until 2023 when I met her. She a insurance agent now and I got closer to her by getting some life insurance and investment plans with her.
Her birthday was recently on 5 April and I got her a jungkook(BTS) funko pop as she really loves BTS like crazy.
We sometimes head over to Johor Bahru once in a while for shopping and food. This gets me to meet her more often but I don't want to ruin this moment by telling that I love her and having my only chance to meet her gone. But I also don't want to wait too long until some other guy takes this chance to get her. I don't know how much will it help me by putting out my story here but I can't lock it in my heart for too long as it's hurting me. So I had to let is out here.
Hi Team,
I have this below code to get the task list from QEM.
# Define the URL for the API call
$url = "https://computer.network.net/attunityenterprisemanager/api/v1/servers/myrepsrv1/tasks"
# Prepare the headers for the API call, specifically the session ID
$headers = @{
"EnterpriseManager.APISessionID" = "wCo0_KvjEUFROvfHF5KGrw"
}
# Make the HTTP GET request and ignore SSL certificate validation errors
try {
$response = Invoke-WebRequest -Uri $url -Headers $headers -Method Get -SkipCertificateCheck
# Check if the request was successful (status code 200)
if ($response.StatusCode -eq 200) {
Write-Output "Tasks retrieved successfully:"
Write-Output $response.Content # Print the response content which includes the task list
} else {
Write-Output "Failed to retrieve tasks, status code: $($response.StatusCode)"
}
} catch {
Write-Output "An error occurred: $_"
}
how to find Session ID of QEM? Pls suggest.. Also I need last week task list using the same.
thanks
Vish123
Hi,
I have a situation where null values are created by another dimension, not true null. I can give these a value by using a count, the return will be 0, then i use if the count = 0 give a value. This is now selectable in the table. Great!
if(aggr(count([Standard Name]),[Production Facility])=0,'No Standards')
However, i now need a button to filter these values and i am struggling to get this. I have tried a few thing with non working. Like using Select values matching search criteria and the value 'No Standards' But i guess this is not a real value!
Does anyone know how i can use a button to filter the created 'No Standards' in the field Standard Name?
Thank you in advance.
Daniel
Hi ,
Can you give some example how to gives access group level qlik sense section access.
I have some requirement like below:
let's we have Total 6 user: They are divided into 2 Group.
How to Give access 2 group different level country access.
ex: 1st group need IND,USA access
2nd group need UK,AUS access
I have provided the Data below
Sales:
Load * inline
[
Year, COUNTRY,Sales
2019, IND, 100
2020, IND, 200
2021, IND, 300
2019, USA, 120
2020, USA, 220
2021, USA, 500
2019, UK, 350
2020, UK, 650
2021, UK, 150
2019, AUS, 850
2020, AUS, 750
2021, AUS, 450
];
Hi ,
Can you give some example how to gives access group level qlik sense section access.
I have some requirement like below:
let's we have Total 6 user: They are divided into 2 Group.
How to Give access 2 group different level country access.
ex: 1st group need IND,USA access
2nd group need UK,AUS access
I have provided the Data below
Sales:
Load * inline
[
Year, COUNTRY,Sales
2019, IND, 100
2020, IND, 200
2021, IND, 300
2019, USA, 120
2020, USA, 220
2021, USA, 500
2019, UK, 350
2020, UK, 650
2021, UK, 150
2019, AUS, 850
2020, AUS, 750
2021, AUS, 450
];
Hi, Guys!
I have a Button with "reload" action in a dashboard , but it only works if the user is the owner of the app.
It is NOT in a cloud enviroment.
Users have professional licenses.
Can you help me?
Hello,
I created Automation that generates report with two fields and one selection in each field.
- Field one:
Fruit:
Apple
Banana
- Field two:
Color:
Green
Red
Yellow
Fruit | Color |
Apple | Green |
Apple | Red |
Banana | Yellow |
I would like to make a selection now to the Apple, and loop through Color and add to separate sheet.
The problem is that if I select Apple from fruit, all colors get selected at once.
How I can select colors one by one, that are only connected to Apple.
I made an automation for this:
- Add Selection To Report: Select Apple from Fruit
- Lock Selections For Field: Fruit
- List Values Of Field: Color
- Add Sheet To Report 4: in each iteration create new sheet
- Add Selection To Report 2 : Color field
The problem is that in each Sheet I get all 3 values selected: Green, Red, Yellow at once.
I want two sheets, one with Green, and one with Red color for Apple, but with List Values Of Field.
I am still learning, so I am sorry if it is simple.
Thanks.
I am testing out the Sankey chart custom object from the Qlik Visualization bundle, and I am having some issues with the link coloring. The default look of the chart gives all links in the same color, making the chart a little difficult to read, see image below:
According to this video from Qlik Help , it is possible to give the different dimension values different colors, making the chart much easier to interpret. At 2:05 in the video, the narrator uses a color code string, "color_hex", in the Link color option under Presentation, and as a result the links are colored according to the source dimension values, see image below:
This "color_hex"-command does not work for me, it is invalid and only results in all the links disappearing. Using single quotes ('color_hex') results in all the links being colored black. Other common color strings like 'blue()', 'lightgreen()' etc works fine, but again, it gives all the links the same color.
I do understand that a possible solution would be a nested IF-statement along the lines of IF(CategoryName = 'Sportswear', blue() .....) for each CategoryName, and then go on to color the links using the 'SOURCE'-command in Link color, but this is not a very good solution, and I would like to avoid it.
Does anyone have a solution for this, am I missing something? I could not find anything in the documentation relating to this either. Thanks!
Hi,
we are using languge/fr (and translation inside the dashboard) to switch to French. however, there are labels or phrases generated by Qlik Sense that we dont have control over that isnt gramatically correct in French. one sample is when you have a stacked bar and you hover over the whole band, the tool tip displays a total + the individual bars. the totals appear to be generated by Qlik Sense (Sum of all positives in EN + a trailing colon). in French it says"Sommes des valeurs positives:". the translation itself is correct but there needs to be a space between "positives".
a few years back i came across an article that suggests there is some language ini file or config file where you can influence the translation. is that still possible? what can we change to add the space that is needed only for FR for this specific test case?
we are using enterprise version
thanks to everyone who can help
edwin
I'm trying to save a script in an app, via the REST API. However, everytime I do POST to /api/v1/apps/{id}/scripts ( ) it saves a new version of the script that shows up in the history. I would rather want to update the current script.
So, using PATCH to api/v1/apps/{id}/scripts/current - but cannot get it to work. I'm getting a 200 but nothing changes. Docs: https://qlik.dev/apis/rest/apps/#%23%2Fentries%2Fv1%2Fapps%2F-appId%2Fscripts%2F-version-patch
This is the REST call definition of my call (wget):
I've tried all kinds of syntax for the NxPatch structure in the body of the request, but cannot figure it out. I can't find any documentation of NxPatch and coming up short in my Devtools in browser.
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!