I have a chart that has data similar to that displayed below

I would Like to be able to do quick what if charts for scenario planning like to show what it would look like if I moved the 50 units of product B from plant 3 to plant 2.  I would like to be able to this in Qlikview and not have to keep changing the input data.  Is this possible in Qlikview or would I need to manipulate data prior to uplaod?

Hi all,

Is it possible to track which sheets users are visiting during there sessions? Any log files?

It may be possible through the QIX engine logs I suppose but I am not sure how to increase the level of logging to do this.

Any help or info would be great!

Hiya, 

I'm currently loading in my data and in my txt file the negatives are shown in Brackets.

This doesn't get read as numbers by Qliksense.

I can't change the load data as this is how it comes out the system. 

Do you know how I can script it to make it recognise them as negative numbers?

Thanks!

Hi, 

I have a a colonne with differents code to exclude the next code:

• CODE  > 401231
• CODE finish by '5*'
• CODE finish by '5A*
• Code don't begin by '603*'

I test this code, but i have errors : 

if(WildMatch(CODE,'*5','*5A'),CODE,
     if(Not WildMatch(CODE,'*603*'),CODE,NULL())
         if (CODE > 401231,CODE)
)

Thanks in advance

Hi, 

I' m trying to pull all the cells from apps is there any method or any request which returns me complete cells from all the apps or from any single app, and what are the parameters should i need to pass for the request, 

please provide me any request object, so that it would be a detail informative and very helpful,

thanks 

i am having a script error on the end of my script when i try to aggregate i can not figure out what is wrong with the script it run well expert for the count at the end any help would be greatly appreciated

[T188T]:
Mapping Load
// Key fields:
[KONDA],
[VTEXT] as [Price Group Descr.]
from $(vSources)T188T.qvd (qvd);

// consolidate the 3 tables of condition price :
[PRICE_COND]:
Load
VKORG as comp_price,
KUNNR as custo_price,
MATNR as mat_price,
KNUMH as cond_price,
DATBI as Valid_to_price,
DATAB as Valid_from_price,
'Customer / Material' as option
from $(vSources)A05.QVD (qvd)
where DATBI > date(today()) and DATAB <= date(today())
;

//added
concatenate(PRICE_COND)

Load
VKORG as comp_price,
KUNNR as custo_price,
MATNR as mat_price,
KNUMH as cond_price,
DATBI as Valid_to_price,
DATAB as Valid_from_price,
'ALL' as option
from $(vSources)A05.QVD (qvd)

;
//endadd
concatenate(PRICE_COND)
load
VKORG as comp_price,
KONDA as custo_grp_price,
ApplyMap('T188T',KONDA) as [Price Group Descr.],
MATNR as mat_price,
KNUMH as cond_price,
DATBI as Valid_to_price,
DATAB as Valid_from_price,
'Price Group / Material' as option
from $(vSources)A32.QVD (qvd)
where DATBI > date(today()) and DATAB <= date(today())
;

concatenate(PRICE_COND)
load
VKORG as comp_price,
MATNR as mat_price,
KNUMH as cond_price,
DATBI as Valid_to_price,
DATAB as Valid_from_price,
'Material with release status' as option
from $(vSources)A304.QVD (qvd)
where DATBI > date(today()) and DATAB <= date(today())
;

//link the condition price table with the pricing table (konp "normal price"/ konm "scale price")
NoConcatenate
PRICE_tmp:
load
comp_price,
custo_price,
custo_grp_price,
[Price Group Descr.],
mat_price,
cond_price,
Valid_to_price,
Valid_from_price,

[custo_grp_price]& '-' &[comp_price] as Pr_Group_Comp,
//[comp_price]& '-' &[mat_price] as Company_Material_Pric,
option
resident PRICE_COND;

left join(PRICE_tmp)
load
KNUMH as cond_price,
if(KZBZG = 'C', ' ', KBETR) as amount_price,
KPEIN as per_unit,
KMEIN as unit_of_measure,
KONWA as currency_price
from $(vSources)KONP.QVD (qvd);

left join(PRICE_tmp)
load
KNUMH as cond_price,
KSTBM as scale_price,
KBETR as amount_scale_price
from $(vSources)KONM.QVD (qvd);

drop table PRICE_COND;

//Add the customer of price group
NoConcatenate
PRICE_tmp2:
load *
resident PRICE_tmp;

/*join(PRICE_tmp2)
load Pr_Group_Comp,
[KUNNR] as custo_price_grp
resident KNVV;
*/
//drop table KNVV;
drop table PRICE_tmp;

//rework the table
NoConcatenate
PRICE_tmp3:
load
//if (isnull(custo_price_grp),[comp_price]& '-' &[mat_price]& '-' & custo_price, [comp_price]& '-' &[mat_price]& '-' & custo_price_grp) as %Company_Material_Pric,
[comp_price]& '-' &[mat_price]& '-' & custo_price as %Company_Material_Pric,
comp_price,
//if (isnull(custo_price_grp), custo_price, custo_price_grp) as custo_price,
custo_price,
custo_grp_price,
[Price Group Descr.],
mat_price,
cond_price,
Valid_to_price,
Valid_from_price,

//Company_Material_Pric,
option,
if (amount_price = ' ', amount_scale_price, amount_price) as amount_price,
per_unit,
unit_of_measure,
currency_price,
if (isnull(scale_price), '1', scale_price) as scale_price
resident PRICE_tmp2
where not isnull(mat_price);

left join(PRICE_tmp3)
Load
KUNNR as custo_price,
[NAME1] as [Cust_price_Name],
KUNNR & ' - ' & NAME1 as [customer code & name price],
[KONZS] as [Corporate Group_Price]
from $(vSources)KNA1.qvd (qvd);

left join(PRICE_tmp3)
LOAD
MATNR as [mat_price],
VKORG as [comp_price],
KUNNR as [custo_price],
KDMAT as [Customer Part Price]
FROM
$(vSourcesShared)KNMT.QVD
(qvd);

left join(PRICE_tmp3)
Load
[KUNNR] as [custo_price],
[VKORG] as [comp_price],
[KONDA] as custo_grp_price

FROM $(vSources)KNVV.QVD (qvd);

[PRICE]:
Load *,
Count(scale_price) as count_scale_price

resident PRICE_tmp3
group by custo_price, mat_price,comp_price ;

drop table PRICE_tmp2;
drop table PRICE_tmp3;

STORE [PRICE] INTO $(vDirectoryPath)PRICE.QVD;

Hello Experts,

I have made some changes on Qlik App and then tried to reload the metadata in Nprintimg connection for the Qlik App. The connection shows cache status as generating for several hours. 
I then deleted the connection and created a new one and it still shows Cache Status Generating as shown below in the screenshot:

Any idea what could be the issue?

Hi,

if i have 2 tables like the following:

TABLE1:

...

TABLE2:

...

How can i Lef Join() TABLE1 with TABLE2 if the first table is before the second in the script?

I can't change the order of the tables because i need to insert an expression in TABLE2 that involve also some fields of TABLE1.

Please, anyone have a suggest?

Thanks,

Mattia

Dear all,

during the development of our apps we have encountered some strange issues by using Qlik Sense.

First of all, let me describe the configuration:

• We are using Qlik Sense February 2019 patch 4
• Our Postgres DB have all values stored as STRINGS, in a table whose columns are (more or less) Timestamp, MetricID, Value. This is because NOT all our stored values are numbers.
• Our environment is configured as Italian (so uses comma as decimal separator for numbers), but in our Postgres DB the numbers are stored represented by using the dot (".") for decimal separator (in order to have a environment independent format).

The workflow is as follows:

1. Importing "as is" the values from Postgres, and storing into a QVD.
2. Read the QVD, filtering out the metrics which we know have actual string values (so we preserve only "numeric" values). [Let's name this QVD#1]
3. Converting the remaining values to numbers: num(num#(Value, '#.#', '.', ','))
4. Storing the converted values into a QVD and into a CSV. [Let's name these QVD#2 and CSV#2]
5. Load the QVD, perform some aggregation on values, such as SUM(), AVG(), STDEV().
6. Storing the results into a QVD and a CSV [Let's name these QVD#3 and CSV#3]

Here the description of the strange behaviors:

• Behav#1: With this workflow, everything seems to go fine, except if we open into the Data Model Viewer the QVD#3, it does not shows the values (it shows "?"). Nevertheless, the resulting plots seem fine. Please note that QVD#2 is shown correctly.
• Behav#2: If, in the step 3 of the flow, instead of using num(num#(Value, '#.#', '.', ',')), we use num#(Value, '#.#', '.', ',') to convert the numbers, the generated CSVs and QVDs have anomalies, as question marks, some numbers are recognized as strings in the model viewer (and some are viewed with dot as separator, others with comma). Also into the CSV there are some anomalies: numbers have different formats (some with comma, others with dot).

From my (very basic) understanding, some issues are due to the dual values management of Qlik. For example, it is likely that the printing of the CSV uses the string representation of the dual values (this should explain BEHAV#2 for CSV).

On the other hand, I am not expecting to have issues with the QVD, since it is a binary format (so I hope numbers are "auto-magically" handled). So I do not get why  I see question marks (BEHAV#1), or mixed number representations in the model viewer (BEHAV#2 for QVD).

So, can someone explain me why I have these issues with the QVD?

Best regards.