Boa tarde,

Preciso de uma ajuda da comunidade, parece ser simples a solução porém oque eu fiz não deu certo aqui. O que tenho hoje é essa tabela, e o resultado final que preciso é a abaixo:

O que acontece, tenho somente a ligação do código do item entre as duas tabelas, os campos Saldo Material e Quantidade Material pertencem a tabele estoque, e os campos pedido quantidade e pedido saldo a tabela Pedido Compra.

O resultado final que preciso é esse abaixo, onde o Saldo Material e Quantidade Material  devem aparecer indepentede do filtro nesse valor, o valor total do que há. Pois minha ideia é mostrar o valor total de estoque, comparado o que foi pedido (Pedido Compra, Mês-Ano, item)

Bom dia,

Algumas vezes noto que quando faço uma simples expressão como:

sum(qtd)*preço 

o campo totalizador da tabela aparece em branco.

mudo para

sum(qtd*preço)

 e ai funciona, mas as vezes o valor está errado.

Parto para uma expressão com o AGRR, mas que quando preciso fazer com uma multiplicação acabo me perdendo.

Qual seria a forma correta para usar em uma tabela dinâmica?

Hello everyone,
Has anyone ever needed to recursively read folders in azure blob storage?
There is a difference between reading folders/files in this location, than reading locally using filelist.

Hello,

we recently upgraded from April 2020 to Nov 2021.

We found that when we set a field as "Always one value selected" in a particular app, the Engine soon crashes.

We also tried using a backup saved before the upgrade, but the problem persist.

We didn't experience engine crashes with April 2020.

Is there a way to diagnose the problem?

Thank you very much,

Gianluca Ferri

HI

Can someone help me with set expression for below

Sum(sales)
WHERE exclusion_category = 'Exception' 
AND SEGMENT = 'Banking' 
AND
(mrkr_set = 'Y'
or offset_ind='Y'
or dbt_ind='Y'
or actv_acct='Y'
or mgmt_ind = 'Y'
or refer_mrkr=0
)

 written expression like below , didn't get the desired results

sum({<exclusion_category={'Exception'},SEGMENT={'Banking'}> *
<mrkr_set_S={'Y'}> + <offset_ind={'Y'}> + <dbt_ind={'Y'}> + <actv_acct={'Y'}> + <mgmt_ind={'Y'}> + <refer_mrkr={'0'}>}sales)

Hi !

I am trying to create stories from a mashup, after spending days  trying from nebula.js, I followed the instructions at https://help.qlik.com/en-US/sense-developer/November2021/Subsystems/EngineAPI/Content/Sense_EngineAPI/BuildingAStory/add-snapshot.htm  and followed it step by step from the Engine Api Explorer.

I succeeded in creating the stories, and slides.  Both appear in the front end, but the final 2 steps (create the slideItem and embed the snapshot in it) don't work. Also, when I try to add objects from the frontend to the created slides, they don't show.

Do anybody had a successful experience with creating slides and embedding snapshot from nebula or from the rpc-json API ?

Thanks in advance for any help

I use Qlik sense server v. 13.102.5

Hii,

I want  to show the comparison of Budget Vs sales in dashboard for current month .

my requirement is show in KPI for Overall budget %, Overall sales % and Overall Budget vs sales % for current month.

Overall means (including all items )

my current Year = 2009

my current month= Apr

help me ..

Thanks in advance...

my data like this..

Hi All,

I am new to NPrinting so please help me in resolving below error

IN Qlik NPrinting when we drag a column to the excel template then after previewing the data comes in a column but my requirement is that I need this data in a row. Like we do the transpose operation in excel while pasting.

EG: IN QS I have a column, when I drag it to Nprinting it comes as

RollNo

1

2

3

But I want this column to be displayed as row

like : RollNo 1 2 3

How can I achieve in Qlik NPrinting itself or any perfect solution with work around

Hi,

We have 2 diferente servers with Qlikview server April 2020 Sr3 and Qlikview Desktop 12.50. One of them was installed a feew days ago to replace the old one. Every month qlikview run a process to cosolidate historial information in a single qvw, this file size is over 27 GB.

On the old server, the process runs without problems, RAM resources and CPU goes to 100% but it works fine and system stores qvw without problems. in the new machine this process takes the same time when it runs on Qlikview desktop but the problem occurs when we try to store this qvw file becase it stops on 2GB and information is not stored completely.  Additionally if the qlikview administration console is open, it closes when trying to record the  qvw  file even while saving operation is processed by qlikview desktop.

The new machine has 180GB of disk free space and the old one has only 55GB.

Attached to this message you can see the machine resources and their differences are locaten on windows server version because the new one has Windows Server 2019 and the old one has Windows Server 2008.

When this new server are storing the and ends this storing process

Somebody can help me?   

Hi all,

I am needing to count distinct account_num but from three different tables but I also need to exclude the count if they appear in another table. I have been using P() for those that match up, but I am having issues on count distinct excluding those in common.

For example: table1 = new customer, table2 = existing customer, table3 = lost customers. 

count({<Table3_account_num=P(table1_account_num), table3_account_num=-P(table2_account_num)>}distinct table3_account_num)

I put a '-' before the P because E() was returning zero and thought at a strech this might work, which it doesn't. 

I should mention all my tables are separate, they are linked by any key. 

essential I want to say, count distinct all account_nums that are in table 3 that are also in table1, but if an account_num is in table 2 then ignore it from the count. 

Any help would be great,