topic Re: empty variables qlik view in App Development

empty variables qlik view

Vern2022 — Wed, 19 Apr 2023 16:50:30 GMT

Why are my variables empty?

[SalesFunnel_DateParams_temp]:

load

date(date#([dateto], 'YYYYMMDD'), 'YYYY-MM-DD')as [datetonew],
date(date#([datefrom], 'YYYYMMDD'), 'YYYY-MM-DD') as [datefromnew];




    SQL SELECT  *
    FROM [BI_DWH_CORE].[Reporting].[v_QV_COM_SalesFunnel_DateParams];
let va = date(date#([dateto],'YYYY-MM-DD'), 'DDMMYYYY');
let vb = date(date#([[datefrom],'YYYY-MM-DD'), 'DDMMYYYY');
let vblog = 'My name is blob!';

letvblob is fine. that was a test. The date variables contain nothing. PS, the fields do return values in qlik view.

Many thanks.

Re: empty variables qlik view

Somasundaram — Wed, 19 Apr 2023 17:24:13 GMT

use this

let va =peek('[datetonew]',0,'[SalesFunnel_DateParams_temp]')

let vb =peek('[datefromnew]',0,'[SalesFunnel_DateParams_temp]')

Re: empty variables qlik view

Kushal_Chawda — Wed, 19 Apr 2023 20:46:23 GMT

@Vern2022 What you want to store in variable? Variable holds single value , you cannot call any field directly.