Hi to all.

Is there a possibility to confiugre the name field in "Master items" -> "Dimensions" (Qlik Desktop in Version June 2019)
with variables so that the field name switches according to set parameters?

Thanxs for advice.

andreascarlos

Dear all,

I'm trying to speedup an SAP incremental extraction of a very large table, the script i'm using is this:

MSEG:
LOAD *,
	MANDT&'|'&MBLNR&'|'&MJAHR&'|'&ZEILE as [%Key MSEG Incremental];
SELECT *
FROM MSEG
	Where .... ;



Concatenate(MSEG)
Load *
From MSEG.qvd (qvd)
	where not Exists([%Key MSEG Incremental],MANDT&'|'&MBLNR&'|'&MJAHR&'|'&ZEILE);

Drop field [%Key MSEG Incremental];


Store MSEG into MSEG.qvd (qvd);

The SAP select is quite fast and in a couple of minutes all new record are extracted, the problem is to concatenate old values with the new ones.

To do this i'm using Not Exists() function by checking the concatenation of key fields of MSEG table.

This last step required more than 30 minutes... is there a way to speedup this check step ?

I have created one QV report in which i have added one chart which shows data.

In that chart properties i have tick fast change allowed type as: Pivot table and Straight table.

My QV desktop version is 12. While selecting one dimension and one measure and changes the type,at that time it is not working.

I have cre

Can anyone help me out please?Because i am just stucked in it and couldn't find out the solution.

Hello,

I need to put one value in powerpoint with Nprinting 18 in defining the text and color by value.

Bu example, If the val>0, put insteaf of val the text 'Positive' in green and If val<0, put insteaf of val the text texte 'Negative' in Red

Thanks in advance for your help

Hi to all!!!

Anyone knows if it´s possible to configure or use a function so an App refresh the data at especifc time every day?

I´m using azure and is possible to open Qlik Sense at specific time but I have not been able to configure the app to refresh  / load the data

Any help will be more than apreciate!!

Hello!

I have a statement: 

=Date(AddMonths(Date#((GetFieldSelections([Rok-Miesiąc], ', ', 99)), 'YY-MM'), -12), 'YY-MM')

and it works if the end user picks only one date - e. g. if he picked 19-06 it prints out the 18-06 value.

If he picks two or more dates it doesn't work, but the statement without AddMonths works perfectly - it prints all the values the user picked.

Why the AddMonths works only for one value? How can I change the statement to make it work?

I tried to use Concat, but it still doesn't work.

How to make the value shown in the chart not exceed the value of the Filter pane? This problem has been bothering me for a long time. Please help me. Thank you.

Note: A supplier has multiple transaction records.