1) I made a reload button through Widget editor by Googling.

2) I want to see it in the form of these buttons in the sheet, but I don't know how.

Or if there is any other way to make a reload button, I would really appreciate it if you could let me know.

please reply if possible
thank you.

I'm working with a table that has these 4 conditions:

Positive quantity & Positive Sale - regular Sale

Negative quantity & Negative Sale - as it seems it's a Return

Positive quantity & 0 in Sale - as it seems it's a gift/promo item

Positive quantity & Negative Sale - can be an error or refund

How can I deal with these different types of sale to calculate margin and margin%? Is it better to convert all the errors/refunds to negative quantities?

Hi all,

I want to use

LOAD ... From_Field (...)

to extract data from a field containing XML structured data. Let's say this is not an issue and I managed to successfully code that (at least on some PoC data).

I'm struggling to connect records in the result of this load with the record in the source table.

As an example - let's say we have a table with Invoices, which contains Invoice Items stored in a single field as XML. LOAD ... From_Field generates the table with all of the Invoice Items, but unless there is a reference to Invoice ID included in XML, I'm not able to link Invoice Items to the specific Invoice.

Also, if the structure of embedded XML is slightly more complex (and therefore I need to load the data using multiple LOAD statements), I have difficulties connecting these tables (autogenerated keys from XML loads reset to 0 with each record). I found out that FileName() function helps, but I'm not really sure if this is the right solution.

Any ideas?

Many thanks.

Hi! I'm currently using requirejs to load qlik on my mashup:

```index.html

\<script

```

 

```index.js

var config = {

    host: window.location.hostname,

    prefix: window.location.pathname.substr( 0, window.location.pathname.toLowerCase().lastIndexOf( "/extensions" ) + 1 ),

    port: window.location.port, isSecure: window.location.protocol === "https:"

};

 

require.config( { baseUrl: ( config.isSecure ? "https://" : "http://" ) + config.host + (config.port ? ":" + config.port : "") + config.prefix + "resources" } );

   

require( ["js/qlik"], function ( qlik ) {

    console.log(qlik);

});

``` 

 

The problem with this approach is that the requirejs provided by qlik import a lot of js modules which last about 12 seconds, which is quite a lot just load the mashup. Is there any other ways to be able to use the qlik API on the mashup?

 

 

 

 

 

Hello, 

I am trying to create the final column in my table below that will flag if the Amount < Expenses Trigger has been hit in 5 days prior to the date of that table row. 

Struggling to make this work so any insights would be greatly appreciated 🙂

お疲れ様です。

GeturrentSelectionsやGetFieldSelections等でステートを指定することが可能かと思います。

指定してない状態ではその式が記述されているオブジェクトのステートが選択されているかと思います。

そこで、例えば「ステート1」に指定されたシートで標準の状態である「<デフォルトの状態>」で選択されているフィルターの情報を上記関数等で抽出したい場合、関数内で指定する必要のあるステート名はどうなりますか？

<デフォルトの状態>ではヒットがしなかったため回答を持っている方いらっしゃいましたらご回答の方お願いいたします。

Hello,

Can anyone please help me with below?

I have a data set 

User      Year    Flag

AAA        2025     -

AAA       2024     Y

AAA        2023    Y

On the SHEET i have a condition to show only if Flag='Y' .

But that SHEET should also appear to user AAA when Year 2025 is selected where Flag is null (because he had Flag = 'Y' in prior years - sheet should show regardless of selected Year if he ever had Flag Y)

Can anyone please help with the condition to use on the sheet for above scenario?

Thanks in Advance

Hi,

I have fact data that needs to be concatenated and because of several reasons I cannot join the columns. So for the example below I would like to calculate with Set analysis the number of issues per Category, but it should calculate as follows:

for Category A : 2 (Issue X and Y) + 1 (Issue linked through Order M)

I believe it is possible with P function in Set analysis, but I cannot succeed with it.. appreciate any help