Hi,

I have two tables with identical fields and want to join the fields to the first table, so that each record will have each record from the 2nd table. Created primary key field by using the script, RecNo() as Key. Both the tables loaded successfully and not sure why  showing script error as Key not found. Can somebody help me with the below error please. Thanks

 Product:

SKU,

[Standard Unit],

RecNo() as Key

from ........;

Hierarchy:

RecNo as Key,

ProdID,

ProductName

From ........;

Join Code 

Left Join (Product)

Load

Key,

Product ID,

Product Name

Resident Hierarchy;

I'm guessing there's an easy solution to this....

Assume I have survey results showing who owns what kitchen items, e.g. in the table below a 1 is Yes:

Next I create a bar chart with dimension Item vs sum(YesNo).

Now suppose I create a dropdown where the user can select an Item, and I now want the bar chart to show the same distribution of sum(YesNo) for each Item, but only for those who responded Yes to owning the Selection in the drop dropdown.  In other words, if Fork is selected in the dropdown, the chart would show the distribution of all Items owned by John and Alan (who own forks).  How would I implement that?  

I created a dropdown to populate a variable vItem, but wasn't sure how to use that in a bar chart expression.  Or should I be using an entirely different approach?

Boa tarde!

Pessoal preciso de uma ajuda...

Criei a conecção e fiz o load de uma planilha simples (teste.xlsx) e nomei a tabela como (dados:), deu certo na hora da carga. Mas quando eu introduzi o código (usei o store...into) para gerar um arquivo qvd (teste.qvd) ele está dando um erro (Cannot open file...Native Path...), eu já o fiz de diversos modos, inclusive segui a sugestão de outros posts aqui de mesmo tema, mas nenhum resolveu.

Desde de já agradeço!

Dear Experts,

Can anyone please explain with example, how i can use where not exist statement in qlik.

I know how we use that statement in SQL.

But i am confuse with qlik.

Thanks in Advance😊

Hello guys.

I am new at QlikView so i need a detailed description as possible.

I want to create a stacked bar like the pic i will attached.

(green=pass, yellow=maybe , red=not pass)

 I want the average of 3 for each previous year and the average for every current month.

Thanks in advance.

Hi all,

I have as an example the following table in excel to load:

I want to load this table an to create new field DRIVER to it such that:

How can I do it?

Thanks in advance