Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i have a what i think is a fairly simple requirement. I need to be able to report on what custom properties all of our users have. I can use the 'monitor_apps_REST_user' connector to access the list of users and there is a sub table for 'customProperties', but although it provides a __KEY_root, the '@value' field is always blank. Also i can't see how to link the user details from root to the customProperties table. Against a user, the custom properties look like this.
How can i achieve a simple app that can report these custom property elements that each user has?
I would really appreciate any help with this, thank you all in advance!
btw, the reason why i'm attempting to do that is because we use these customProperties to assign stream access, a fairly common approach, but i have no way of reporting who has access to each stream without checking each user individually. There are security/monitoring apps that can tell me who has accessed streams and apps but not who has the potential to access them.
Need Help. I would like to make a Bar chart like above. For Machine X, I want to show Jan (50 pcs) and Feb (40 pcs) production quantity separately. Then third bar will show sum of two months (90 pcs). Anyone can help me please? Thanks.
One of on our tasks, we periodically get the following error messages:
Unable to get TABLE_DEF for capture table [dbo.TableNAme]
Failure in associating MetadataManager TABLE_DEF with CDC_TABLE_ENTRY"
We are using SQL Server RDS as an Endpoint - NOT MS-CDC.
Any help is appreciated!
Hi All,
I need assistance with suppressing zero values in a Qlik Sense variance waterfall chart. While other charts in the properties panel typically offer an option to include or exclude zero values, this option seems unavailable for the Variance Waterfall chart.
Could you suggest a solution for suppressing zeroes, or recommend an alternative chart type?
Your response would be greatly appreciated. Thanks
Regards,
Pui Jie
Hi guys, I have an input table with the % of comission for each Product Type Sale for each SalesMan.
The table looks like this (in the real case the SalesManID is dynamic, it's not only for 4 salesman) :
4 | 5 | 12 | 14 | ||||
CompanyCode | FamilyCode | SubFamilyCode | FamilyDescription | SalesmanId4 | SalesManId5 | SalesManId12 | SalesManId14 |
1 | ANIM | ********** | XXX | 10% | 5% | 10% | 10% |
1 | APPR | ********** | YYY | 5% | 10% | 5% | 10% |
1 | AV | ********** | ZZZ | 10% | 10% | 10% | 5% |
And I'd like to get an output of a desired table like this :
FamilyCode | SalesManId | %Comission |
ANIM | 4 | 10% |
ANIM | 5 | 5% |
ANIM | 12 | 10% |
ANIM | 14 | 10% |
APPR | 4 | 5% |
APPR | 5 | 10% |
APPR | 12 | 5% |
APPR | 14 | 10% |
AV | 4 | 10% |
AV | 5 | 10% |
AV | 12 | 10% |
AV | 14 | 5% |
Could anybody help me please? I don't know if crosstable it's the best option, I'm trying to do it but with no results.
PD : I've attached the example in excel, in order to make it easier for everyone to understand.
Kind regards, Marcel.
My Task without filter condition has already completed full load, now I want to add a new filter condition for CDC records to exclude some records based on source column value.
I tried with adding below filter condition and record selection condition but both scenarios I am getting weird results:
Col Name is Cloud_migrt_ind.
CLOUD_MIGRT_IND |
STRING(1) |
Regular |
Exclude |
'Y' |
Can you suggest the best way to add filter condition to exclude record based on column value ?
Thanks,
Srinivas
Hi QV Community, i need help i hope any one can help me.
I have a project to publish a vector image, a map converted to vectors, I have already made the map, it is already connected to the database, on the desktop it works very well, but when I want to see that published image, the report does not show it .
Any idea, Tks.
Hi,
Hoping this is a simple answer. In summary, the STDEV expression I have below is not working.
Hi,
I want to add reference line on my x- axis.
my x-axis is my ItemID.
my Y axis is cumulative margin.
I tried to crate whale chart and I want to know where is the spot when my whale chart start to descending with the reference line.
this is my line chart so far:
I tried to add the reference line with this expression:
Aggr(If(Rangesum(above(total ROUND(sum(margin)),0,RowNo())) = Max(total Rangesum(above(total ROUND(sum(margin)),0,RowNo()))), ItemID), ItemID)
but I don't see any line on my X-axis..
Can someone help me please?
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.
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!