We upgraded from 12.1 to 12.4 (April 2019 SR1) this past weekend.  Now when users right click on a chart heading and select Export from the menu, try to open the download it opens in Excel with semi-colons and all the data in the first column.  See comparison in first and second images.  I also checked the Regional settings on each server as well as tried the UseIcuForLocaleInfo=0 option in the settings.ini file.  Restarted services and restarted servers but nothing has solved the issue.  I coudn't find a knowledge article from Qlik.  Any other things i can try?  Thanks

This is what it looked like previously:

I read another post regarding the regional settings on the server.  We have four web servers and i checked them all and they all appear correct.

Hi everyone,

Just migrated from QlikSense Cloud Business to Cloud Editions of QlikSense Business.  What the difference is confuses, but not my issue!  In the QlikSense Cloud Business version we were using section access and I need advice on how to use this in the Cloud Editions of QlikSense Business version.

Specifically:

1 - what are the user IDs in the Cloud Editions of QlikSense Business version including the domain?  

The domain for QlikSense Cloud Business  was QLIKCLOUD.  Is this still the same for Cloud Editions of QlikSense Business version?

Using the SubField(OSUser(),';',-1) expression, the QlikSense Cloud Business version gave me this  "UserId=qlikid_jeremy.dyer" but the Cloud Editions of QlikSense Business version is giving me this "UserId=auth0|111d4335-8c92-4b7f-af70-12189dd8ae82".   Am I correct that this is the ID?

2 - what is the service account?  Is it still INTERNAL\SA_SCHEDULER?

Thanks 🙂

Carl

Hi,

I have an expression as follow:

=if(dim=a, 123*sum(time), if(dim=b, 234*sum(time), if(dim=c, 345*sum(time)))).

I understand that for the total, it cannot calculate the expression due to the fact that there is not a specific dimension, but is there a way around?

Thank you!

Hi all,

I have a drill down dimension.Ex. Country,city,District , store

My measure is sum (total <dimension> sales )

Here how do i change the dimension value according to drill down.

Please help me..

Hello,

I have 2 datasets one is xlsx and another in csv format.

When I loaded the data to qliksense desktop the csv file date field is working but the xlsx one doesn't.

I have tried date(datefield,'DD-MMM-YYYY') and date(date#(datefield,'DD-MMM-YYYY'),'DD-MMM-YYYY') but it doesn't.

When I left it as datefields only it has shown like the attached picture.

Please help.

Hello , working with QlikSense and Jira across a portfolio and currently Jira has not been migrated to QlikSense meaning two data sources for a project. Any ideas experience on best practice.

Hi Guys

One of our clients is creating a new domain, and as part of this project, would like to move their QlikSense server to the new domain.

I've had a look on the Qlik Help, and there doesn't seem to be any recommended steps for this sort of move.

Our initial thoughts are to do the following:

1. Create a new local admin account on the server, give this rootadmin access to QMC
2. Create replica accounts on the new domain for Qlik Services etc
3. Change the domain on the server
4. Change the Qlik services to the new AD accounts
5. Log into QMC as the new local admin account
6. Change ownership of apps
7. Configure UDC on new domain
8. Ensure new AD users users have correct tokens etc

Another idea is to uninstall and reinstall the QlikSense environment once the domain is moved?

Has anyone done this before? Any thoughts or recommendations?

Hi All,

I have one list box in that  having values are Sales, SalesR, SalesE, Region, RegionE, Central.

in the same i have Charts like Sales, SalesR, SalesE, Region, RegionE, Central.

if i select the Sales in the list box then select the Sales chart, if i select Sales, SalesR values then display the Sales, salesR charts if no selections from the list box then hide the charts.

if i select the sales and Central then display the Sales, Central charts.

if i select sales and salesR it will display First and Last chart, but if i select the sales and central it is showing First chart and last chart Reaming is showing empty. But i want to show one by one in without space.

Please Suggest me this scenario is  Possible or not, if possible please suggest me how to achieve this scenario.

if possible please share me example.

Thanks & Regards,

Lakshman

Reading lots off order line till end off week to qvd , since they do not change anymore

in a new week i read  that qvd , that during that week orders are added or updated

orderlines have a unique key wich goes to qlikview also 

i would like to reread and/or add new orderlines to the dashbord and update after that dashbord for changes

either by a timer or manual, or some trigger

is this technical possible or wishfull thinking?

Hi All,

hope you all good.

I'm trying to figure out the way, how to handle section access for sub tabs in sheet.

Example: I have Sales and Market as a sheet in my application with two sub tabs in each sheet.

what i want is If USER A  goto Sales Sheet , he should see only Tab1 related data and if he goto Market sheet   he should see Tab2 related data only.

Note : there is no connection for tabs and data filter in data, its only related to what we are showing in each tab.

Hope this clear. ref sample app in attachment

Regards,

Subbu