topic Re: how to add two values in a field when it is using dimension in a chart in QlikView

how to add two values in a field when it is using dimension in a chart

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

Hi all,

I have a field "Name" as below.

Name

i need two extra values in the above field when it is using in chart.

Answer:

Name

how it is possible?

Re: how to add two values in a field when it is using dimension in a chart

Anonymous — Tue, 08 Nov 2016 16:54:46 GMT

You can load those in script from inline tables like as below and use other columns similar to your existing table

'E' as Name

'F' as Name

Re: how to add two values in a field when it is using dimension in a chart

trdandamudi — Tue, 08 Nov 2016 16:55:50 GMT

You can try as below as dimension:

=ValueList('A','B','C','D','E','F')

Re: how to add two values in a field when it is using dimension in a chart

jeevays7 — Wed, 09 Nov 2016 15:54:14 GMT

Hi subhasmita,

i need in front end for one table only. can i do?

Re: how to add two values in a field when it is using dimension in a chart

jeevays7 — Wed, 09 Nov 2016 15:55:26 GMT

Hi thirumala,

I need a vlues with a field from datasource, that filed not fully in valuelist.

Re: how to add two values in a field when it is using dimension in a chart

Anonymous — Wed, 09 Nov 2016 17:10:54 GMT

Can you upload a sample file for your scenario?

Re: how to add two values in a field when it is using dimension in a chart

MarcoWedel — Wed, 09 Nov 2016 21:34:35 GMT

Hi,

you could trick a chart into showing additional values with the already suggested ValueList() function using only the field name of your loaded data like this:

LOAD *,
     Ceil(Rand()*100) as Value
INLINE [
    Name
    A
    B
    C
    D
];

Downside is, you can't select in this chart.

Can you share an application to show what you're trying to present as expression values for the additional dimension values? Maybe there is another way to do so?

hope this helps

regards

Marco

Re: how to add two values in a field when it is using dimension in a chart

johnw — Thu, 10 Nov 2016 00:24:06 GMT

Can you explain why it must be in the chart and not in script? I might handle this sort of case by adding a new table with a field that has the more complete list, and connecting it to the other field when the values match. Something like this:

MoreNames:
LOAD *,Name as MoreName;
LOAD text(fieldvalue('Name',recno())) as Name
AUTOGENERATE fieldvaluecount('Name')
;
CONCATENATE (MoreNames)
LOAD subfield('E,F',',') as MoreName
AUTOGENERATE 1
;

And then do the chart like this:

Dimension = MoreName
Expression = alt(Value,100)

Borrowed Marco's QVW and added to it. See attached. There are differences in behavior even if they appear the same on the surface. You CAN select in the chart, but it may not behave exactly as someone expects, since it isn't selecting the Name. And if you do select a Name, E and F disappear from my chart, but not from Marco's.

Re: how to add two values in a field when it is using dimension in a chart

varshavig12 — Thu, 10 Nov 2016 03:21:17 GMT

Try this:

LOAD * INLINE [

Name, value

A, 11

B, 22

C, 33

D, 44

];

load * Inline [

kpi

];

Presentation tab----uncheck suppress Zero-Values.

Re: how to add two values in a field when it is using dimension in a chart

jeevays7 — Fri, 11 Nov 2016 05:32:28 GMT

Hi macro,

thank you so much.

Re: how to add two values in a field when it is using dimension in a chart

jeevays7 — Fri, 11 Nov 2016 05:33:49 GMT

Hi varsha,

thank you so much.

Re: how to add two values in a field when it is using dimension in a chart

varshavig12 — Fri, 11 Nov 2016 08:21:53 GMT

You are welcome