Welcome to Qlik Community

I'm migrating our Qlik Sense to a new server for to a technology update.
We created a server image and then restored it to a new server in the same domain.
So, the services are up, but I can't use Qlik by qmc and hub.
I'd like to know what best practices are for completing the migration and getting started using Qlik on the new machine.

Hello Community 

I have 2 groups of user : Sales and Finance and I am trying to allow my users to have access to different sheets located in the same app called "Report" located in the stream "Invoices" so I followed every step of the following post : https://community.qlik.com/t5/Qlik-Sense-Documents/Sheet-or-App-Object-Level-Security-Qlik-Sense/ta-p/1485114

I started by creating two custom properties : @ApplvlManagment and @StreamlvlManagment with the following values :  "Sales" and "Finance" for my two group.

After assigning the custom properties to the stream, app and users I created a first rule on App.Object_* : user.@AppLevelManagment=resource.@AppLevelManagment and two other rules : one manage the app object access for the Finance group and the other manage the app object acces for the Sales Group.

I had to disable the default stream rule but I couldn't see my apps without it so I cut only the second part of the rule: "or ((resource.resourcetype = "App.Object" and resource.published ="true" and resource.objectType != "app_appscript" and resource.objectType != "loadmodel") and resource.app.stream.HasPrivilege("read"))"

Now it is working well I can see only certain sheets with the Finance group and other sheets with the Sales group located within the same app. My problem is that I have other streams and my users cannot access to the app object of those streams anymore. I know it is because I deleted the part that granted App.Object access in the stream default rule.

Is there a meaning to override the stream default rule and write an other one to still have my users of the two group Finance and Sale separated within the app "Report" while allowing them to keep seeing the AppObject contained in other apps within other streams ? 

Hi,

what’s the best way to do the following.

Count all employees

If(count({<field = {yes}, field2 = {no}>}counter) = 1,1,0)

I need to do aggr counting all the employees where there’s a 1 in the IF statement.

the expression is to go into a table with 1 row of data, I don’t want to add the employees field, hence I think I’ll need a aggr.

thanks

My data has separated Day and hour(=Zulu), and I need to draw a time series plot with the order of Zulu/Day/Month/Year.

Such an order of 0/01/01/2020  ->  1/01/01/2020  ->2/01/01/2020    and so on..

How can I adjust them at the load editor?  or can I combine and adjust them directly and  a plot chart?

In our Environment we have a master project and several other projects where developers make changes. For one of these projects I imported the Entity and Mapping changes from the UI. Validate worked for the DW and DM. 

Next I exported the project CSVs and merged the DM changes from the Developer's project into the Master. There were changes to around 5 Facts and 6 Dimensions.  The import completed successfully using the CLI.

Upon running validate Compose throws the following error in Master. 

How should we go about debugging this issue? In the past I have tried to restore a backup and tried to bring one Dimension or fact at a time. Is that the ideal way or is there a way to query the sqllite db or json file to identify the root cause of this issue? 

Hello,

I have a question that i cant seem to solve.

I have the following table:

Since, the region is the same and the targets are the same, can we have the total to be 1,350,000 since all targets in the regions are the same?

Thank you in advance.

Waleed

I had split out a column in the data manager to 3 total new columns. In a bard chart I am looking to merge the values which I accomplished with the below formula:

=pick(match($Field,'Competitor Name-1','Competitor Name-2','Competitor Name-3'),[Competitor Name-1],[Competitor Name-2],[Competitor Name-3])

BUT now I am wanting to remove a specific value from the Competitor list (for each dimension). How can this be accomplished?

Dear friends

I have marked the Currency field in a Sales-app with "Always one selected value". But it gets unmarked when I reload the app with Section Access. Any idea how to solve this issue?

We are on release Qlik Sense Aug 2021 SR1

Thanx Johan

Hello. I'm having an issue with my expression. I'm trying to count any time that the status changes and the status type is either one of these status types. I don't know what I'm doing wrong here, says I'm missing a ) somewhere? Thanks for the help.

COUNT(DISTINCT if(StatusChanges > 0 AND (SP_StatusType = 'ONSITE' , OR SP_StatusType = 'TRIAGE', OR SP_StatusType = 'REPAIR IN PROGRESS', OR SP_StatusType ='LEAVING SITE',
OR SP_StatusType = 'PRODUCT SHIPPED'),SP_RFACallNumber))

/

Count(DISTINCT SP_RFACallNumber)