topic Re: Report Hardcoded values in QlikView

Report Hardcoded values

priyarane — Fri, 24 Apr 2015 06:58:46 GMT

Hi Experts,

I have built the data but now need to put some filters which is not present in the source but still I need to hard code those values.

I am bit confused to put the values(Dummy/Hardcoded values). So please help me where to add dummy data.

For filtes and source data and my app added as attaced. It should work properly in association wise.

Re: Report Hardcoded values

jonathandienst — Fri, 24 Apr 2015 07:32:14 GMT

You could put the values in variables or with inline loads into fields.

For variables - set in your load script:

Set vLimit1 = 0.85;

Set vLimit2 = 1.05;

For in line loading:

Limits:

LOAD * Inline [

Type, Upper, Lower

A, 0.8, 1.05

B, 0.95, 1.01

];

After reloading, you will be able to use these values in your chart and table expressions.

HTH

Jonathan

Re: Report Hardcoded values

priyarane — Fri, 24 Apr 2015 07:54:28 GMT

Hi Jonathan,

Thanks for reply,

But how can I get filters then

Legal Entity

HNAH_CIB

HNAH_CISA

HNAH_SB

HNAH_SA

Line of Business
LOB1
LOB2

Scenario Type
Sce1
Sce2

Reporting Period
11/30/2014
12/30/2014

Re: Report Hardcoded values

ankitaag — Fri, 24 Apr 2015 09:32:45 GMT

Hi Priya,

How would you liunk those filters to your dashboard?

Re: Report Hardcoded values

priyarane — Fri, 24 Apr 2015 09:44:25 GMT

Hi Ankita,

Yes these reports are prototype so no data for filtes so I wanted to hard code the values for filtes and I have to show them on dashboard

Re: Report Hardcoded values

ankitaag — Fri, 24 Apr 2015 09:53:08 GMT

So, you can directly create Inline tables for all the filters and display them in the list box:

LegalEntity:

LOAD * INLINE [

Legal Entity

HNAH_CIB

HNAH_CISA

HNAH_SB

HNAH_SA

];

LineOfBusiness:

LOAD * INLINE [

Line Of Business

LOB1

LOB2

];

ScenarioType:

LOAD * INLINE [

Scenario Type

Sce1

Sce2

];

ReportingPeriod:

LOAD * INLINE [

Reporting Period

11/30/2014

12/30/2014

];

Re: Report Hardcoded values

priyarane — Fri, 24 Apr 2015 10:33:41 GMT

Hi Ankita,

That is correct. But values will not be change if I place those on dashboard.

So I am looking something like, can we add data as source even if it is hard coded.

if nothing is possible then I will do create as you suggested and I will concatenate those.

Re: Report Hardcoded values

ankitaag — Fri, 24 Apr 2015 10:47:25 GMT

Hi Priya,

That's why I asked you that If you want these hard coded filters then how will you link your source tables.There is no connection between them

So to make the data change you need to add data in your source excel

Re: Report Hardcoded values

priyarane — Fri, 24 Apr 2015 12:27:46 GMT

Hi Ankita,

I will add it

Re: Report Hardcoded values

ankitaag — Fri, 24 Apr 2015 12:38:17 GMT

sure