topic Re: How To Add Hard coded field to Straight Table in QlikView

How To Add Hard coded field to Straight Table

SatyaPaleti — Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

I really need a help for following Issue

I am Having a Straight Table. In that I need to show one particular field as a Target. Here is the Detail Requirement

I am getting Total. There should be one more column which is followed by Total it is Target.

Target is a Hard coded Column. It Have to show in Straight Table

Here is the excel how I need to show

Could you please help on this. Here you can find Sample data and Sample Qvw

Thank you,

Satya Paleti

Re: How To Add Hard coded field to Straight Table

sunny_talwar — Tue, 14 Jun 2016 15:47:47 GMT

Like this?

Expression:

=If(Dimensionality() = 0, 9.2, Avg([Total Sale]))

Enabled Total on the dimension limit tab

Re: How To Add Hard coded field to Straight Table

SatyaPaleti — Tue, 14 Jun 2016 16:01:16 GMT

Thank you sunny. but it's not working.if we add two or more expressions

Re: How To Add Hard coded field to Straight Table

sunny_talwar — Tue, 14 Jun 2016 16:07:25 GMT

What are the expressions you are using?

Re: How To Add Hard coded field to Straight Table

tamilarasu — Tue, 14 Jun 2016 16:07:38 GMT

Hi Satya,

Could you please post your script here. I am using personal edition.

Re: How To Add Hard coded field to Straight Table

sunny_talwar — Tue, 14 Jun 2016 16:09:08 GMT

This is not what you want?

Re: How To Add Hard coded field to Straight Table

sunny_talwar — Tue, 14 Jun 2016 16:09:33 GMT

Here it is Tamil:

LOAD Week,

[Total Sale],

[Total Org Id],

Columns

FROM

[Sample_Data.xls]

(biff, embedded labels, table is Sheet1$);

Re: How To Add Hard coded field to Straight Table

SatyaPaleti — Tue, 14 Jun 2016 16:12:20 GMT

Exactly that is what I Require

Re: How To Add Hard coded field to Straight Table

SatyaPaleti — Tue, 14 Jun 2016 16:12:39 GMT

could you plzz send ur mail ID

Re: How To Add Hard coded field to Straight Table

sunny_talwar — Tue, 14 Jun 2016 16:14:01 GMT

So I added another expression and it seems to be working

Re: How To Add Hard coded field to Straight Table

SatyaPaleti — Tue, 14 Jun 2016 16:20:14 GMT

There is some other expressions just like sum(Total Org Id ) and Sum(Columns). If I add these. then it's throwing error Sunny

Re: How To Add Hard coded field to Straight Table

sunny_talwar — Tue, 14 Jun 2016 16:20:58 GMT

Can you add it to the attached qvw and share it with me?

Re: How To Add Hard coded field to Straight Table

SatyaPaleti — Tue, 14 Jun 2016 16:23:21 GMT

Sunny Can you share your mail Id

Re: How To Add Hard coded field to Straight Table

sunny_talwar — Tue, 14 Jun 2016 16:29:30 GMT

Would you be able to send me a private message so that I can share my id with you