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

Thank you,

Satya Paleti

Re: How To Add Hard coded field to Straight Table

Anonymous — Tue, 14 Jun 2016 14:46:35 GMT

I don't think that this is possible

as I had this Kind of requirement, I found a workaround

maybe this would be an Option for you

-> create the straight table and a textobject with your target column

create a Container and put both objects next to each other

you may Format the objects to your requirements

disadvantage: by exporting to Excel you can only export the straight table

Re: How To Add Hard coded field to Straight Table

Anonymous — Tue, 14 Jun 2016 14:48:28 GMT

Hi Satya,

See attached.

Regards!

Re: How To Add Hard coded field to Straight Table

marcus_sommer — Tue, 14 Jun 2016 14:49:18 GMT

For this you need to add a further dimension which could be a calculated dimension, for example:

= 'All weeks'

which you put above your weeks and then you enabled partial sums (with the label Target for it) for this dimension and you used a query on the dimensionalities within the chart to assign the right expression, for example:

if(secondarydimensionality() = 0, TargetExpression, YourNormalExpression)

- Marcus

Re: How To Add Hard coded field to Straight Table

SatyaPaleti — Tue, 14 Jun 2016 15:02:01 GMT

Hi Manuel,

I didnt get any Attachment could you plz forward to satyapaleti@gmail.com

Thank you,

Satya