topic Display value dimension as different value in QlikView

Display value dimension as different value

Fri, 23 Sep 2016 14:30:33 GMT

Hi All, I need to display my records as different value in the dimension of Pivot Table.

For example I have Field A which consist value 1,2,3,4,5,6,7, and 8. I want to display value 3,4,5 as 'A' in the dimension and the expression will accumulate for value 3,4,5 in dimension value A. How can I do this in Pivot Table.

Thanks

Field A	Express
1	Value XXX
2	Value XXX
A	Value XXX
6	Value XXX
7	Value XXX
8	Value XXX

Re: Display value dimension as different value

Digvijay_Singh — Fri, 23 Sep 2016 15:35:20 GMT

Try this -

Map:

Mapping load * inline [

FieldA,Value

3,A

4,A

5,A ];

Load Applymap('Map',FieldA) as FieldA,

Expression

inline [

FieldA,Expression

1,100

2,100

3,100

4,100

5,100

6,100

7,100

8,100 ];

Re: Display value dimension as different value

Digvijay_Singh — Fri, 23 Sep 2016 15:49:00 GMT

Front-end based -

Re: Display value dimension as different value

nagarjuna_kotha — Fri, 23 Sep 2016 16:03:26 GMT

Like this?

Check attached How to do it in front end and backend

Hope this may help 🙂

-Nagarjun

Re: Display value dimension as different value

el_aprendiz111 — Fri, 23 Sep 2016 16:43:28 GMT

Hi,

Re: Display value dimension as different value

Tue, 27 Sep 2016 11:38:19 GMT

Hi,

Its works. Thanks so much!

Re: Display value dimension as different value

Tue, 27 Sep 2016 11:38:36 GMT

Hi,

Its works well. Thank you so much!