topic Re: Variable value in your inbox in QlikView

Variable value in your inbox

Fri, 19 Jun 2015 13:02:25 GMT

I'm putting an inbox , but I need the value of the Inbox variable come a selected value of a field . But when I put the term in the input box value , he appears but when I store the variable it appears only the expression and not the calculated value. Could anyone help me ?

Re: Variable value in your inbox

awhitfield — Fri, 19 Jun 2015 13:04:05 GMT

HI Rodrigo,

can you upload an example qvw please?

Andy

Re: Variable value in your inbox

Fri, 19 Jun 2015 13:26:35 GMT

Example!

Re: Variable value in your inbox

sunny_talwar — Fri, 19 Jun 2015 13:35:09 GMT

Try this in your script (I am unable to reload and test because I don't have the source data)

LET vDatadecadastro=(Date(now(),'DD.MM.YYYY'));

Base:

LOAD CATEGORIA AS Categoria,

[SUB CATEGORIA] as subcategoria

FROM

TESTE.xlsx

(ooxml, embedded labels, table is Plan1);

NoConcatenate

STATUS:

LOAD Evaluate(CATEGORIA) as CATEGORIA,

Evaluate([DATA DO CADASTRO]) as [DATA DO CADASTRO],

Evaluate(SUBCATEGORIA) as SUBCATEGORIA,

Evaluate([CODIGO DO STATUS]) as [CODIGO DO STATUS]

Inline

[CATEGORIA , DATA DO CADASTRO , SUBCATEGORIA , CODIGO DO STATUS

$(vCategoria) , $(vDatadecadastro) , $(vSubcategoria) , $(vCodigo_STA)]

;

STORE STATUS into STATUS_$(vCodigo_STA)-$(vDatadecadastro).qvd ;

DROP Table STATUS;

DENUNCIAS:

LOAD CATEGORIA,

[DATA DO CADASTRO],

SUBCATEGORIA,

[CODIGO DO STATUS]

FROM

STATUS_*.qvd

(qvd);

Re: Variable value in your inbox

Fri, 19 Jun 2015 15:19:36 GMT

It gave error