topic Re: Input Field em grafico in Brasil

Input Field em grafico

Mon, 06 Apr 2015 12:02:16 GMT

Bom Dia Pessoal tudo bom ?

Hoje eu venho uma duvida mais legal, negócio e o seguinte, eu tenho um campo com itens ele possui por exemplo: regua, caneta, lapis, caderno ( inicialmente) e eu preciso desenvolver uma calculadora que : o usuário irá digitar a qtd do item + valor de custo e gerar o valor total do item como exemplo abaixo:

Item ------- Qtd ------- valor ---- total

Caneta --- 10 ------ 0,20 = 2,00

Regua --- 15 ------ 0,30 = 4,50

Caderno --- 10 ------ 1,20 = 10,20

Lapis --- 10 ------ 0,10 = 1,00

Como fazer isso no Qlikview? para item que possui ?

Re: Input Field em grafico

sunny_talwar — Mon, 06 Apr 2015 12:27:38 GMT

Maybe this will help (Please find attached)

Best,

Sunny

Re: Input Field em grafico

Mon, 06 Apr 2015 12:38:36 GMT

This is like is need but i have more itens...use inputfield and load but my dimension of itens, its going work?

Like:

inputfield qtd;

inputfield price;

input.Item:
Load

Base.item,

0 as qtd

0 as price

resident Base.Item

Re: Input Field em grafico

sunny_talwar — Mon, 06 Apr 2015 12:40:54 GMT

I think it should work like the way you have put down there. Let me know if it doesn't.

Best,

Sunny

Re: Input Field em grafico

Mon, 06 Apr 2015 16:20:41 GMT

In My case is not work =(

I create a new dimension for this and the field not came like a inputfield

Re: Input Field em grafico

sunny_talwar — Mon, 06 Apr 2015 16:23:01 GMT

Can you post your exact script here?

Best,

Sunny

Re: Input Field em grafico

Mon, 06 Apr 2015 16:38:56 GMT

Sure

I seding d Excel whith my itens and qvw + script

Re: Input Field em grafico

sunny_talwar — Mon, 06 Apr 2015 16:43:59 GMT

Isn't this working?

Re: Input Field em grafico

Mon, 06 Apr 2015 16:57:50 GMT

That Way work because your Inline is loading, remove your inline and see what happend

Re: Input Field em grafico

sunny_talwar — Mon, 06 Apr 2015 16:59:53 GMT

My inline script is commented out.

Re: Input Field em grafico

Mon, 06 Apr 2015 17:01:44 GMT

Maybe is because of my Qvd file?
Could be that ?

Re: Input Field em grafico

sunny_talwar — Mon, 06 Apr 2015 17:03:17 GMT

You are loading data from a qvd? I don't think that should be an issue also. Not entirely sure what the issue is until I see exactly what you are doing.

Re: Input Field em grafico

Mon, 06 Apr 2015 17:16:28 GMT

I Discovery the Problem

I Doing

INPUTFIELD nQuantidade;

INPUTFIELD nValor;

TmpItem:

LOAD Distinct

cItem

FROM

(qvd);

Item:

LOAD

cItem,

0 as nQuantidade,

0 as nValor

Resident TmpItem;

That Way for some reason not work just work when i use:

INPUTFIELD nQuantidade;

INPUTFIELD nValor;

TmpItem:

LOAD Distinct

cItem

FROM

(qvd);

Item:

LOAD Distinct

cItem,

0 as nQuantidade,

0 as nValor

Resident TmpItem;

I have to use 2 times distinct O.o

Thx for the help

Re: Input Field em grafico

sunny_talwar — Mon, 06 Apr 2015 17:18:10 GMT

Not a problem, I am glad I proved to be of help.

Best,

Sunny