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.     

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) :

And I'd like to get an output of a desired table like this :

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'

•  $CLOUD_MIGRT_IND != 'Y'

Can you suggest the best way to add filter condition to exclude record based on column value ?

Thanks,

Srinivas 

Hi, 

Hoping this is a simple answer. In summary, the STDEV expression I have below is not working.