Welcome to Qlik Community

Hi All,

Is there any way to pass field value in QlikSense App url having special characters.

Below URL is working 

http://test/appid/test/sheetid/test/select/name/abc

Below URL is not working

http://test/appid/test/sheetid/test/select/field/IQG2HN?OM#P&RY?_\NY7.+2\,>D:BE2^36?PW>,73J

Please suggest how we can pass  special characters in URL

Hello everybody,

I have a problem that has been haunting me for several days. I have a table with this data:

| date | quantity |

Quantity is the daily stock of the warehouse.

I have a table as a master calendar which shows the date, week, year, etc.

My goal is to calculate the weekly variation ... how can I do?

I attached the tables..

data table:

expected result:

part of master calendar

I have a calculated x-axis that ranges from -19.20 to 800.72. Usually in Qlik View we can use Axes --> scale --> Static Min; Static Max boxes to set ranges for x-axis. But dont know how to do it in Qlik sense?

Infact I dont even have Range option showing up for my X-axis. Only for Y-axis I have my Range option.

My calculated dimension is "=num(Minute/60 , '##.##' )"

Any help will be much appreciated. Thank you.

Hi, I know there are a number of threads that have been raised regarding aggregation in QV scripting and have looked through a lot of them to try and solve my issue.

I have a fairly decent size data set stored in a QVD (7.5 million rows).

I have written a load script to extract some of this data and aggregate it together.

My source fields are PositionId, ForecastDate, ForecastHours

on my initial load into a temp table I have -

temp:

Load

PositionId,
week(ForecastDate) as FWeek,
ForecastHours

From

c:\datasource\data.qvd (qvd);

I then have a final table -

final:

load
PositionId,
FWeek,
sum(ForecastHours) as Fhours
resident temp
Group by PositionId, FWeek;

Drop table temp;

This should be as simple as can be, if I use a simple inline table as my source (with about 15 rows) I get the correct data out. However when I use my real data source my FWeek AND ForecastHours are  both showing incorrect.

Hopefully someone has an idea of what I am doing wrong and how I can fix it.

Thanks

Chris

Hi, I'm trying to remove borders on Navigation Button.

The button have a borders because I've inserted a css code like this

I've inserted that code because I  have a requirements regarding how the chart should look. But I also have a requirements that the buttons should not adapt the border and border color of a chart.

I have searched and have not find one of any documentation or examples of configuring the css style of a navigation button.

I hope it is configurable!

Thanks.

Hi,

We started using the .net SDK in combination with the Qlik-Cli for Windows version for deploying apps to multiple streams.
For every stream we would like to change some variables in the Data load editor. Is that possible with the SDK? I found some options for changing the script with the engine JSON api but not with the SDK.

We have these 3 variables that we use to connect databases, we would like to change for every stream:

let CustomerName = 'CustomerA'
let DWH_CustomerName = 'DWH_CustomerA'
let Source_CustomerName = 'Source_CustomerA'

Would it be possible to search and replace these variable values in the load script?

Kind Regards

Hi, 

On Qlik Sense I have a map with an area layer, is it possible to hide the label "area layer" (= "couche de zone" in the screenshot). I want only the legend