topic Re: Re: how to create the value using existed value in QlikView

how to create the value using existed value

ravindraa — Tue, 25 Nov 2014 11:57:32 GMT

Hi all,

i have struck one place please give me any suggesion to come out from that.

My requierment is i have one Division , Sector Fields.

in sector field these are values:: XY

In Division Field these are Values::

areoplanespears

autospears

domestic

international

unitdivision

In the Chart i have to show the Divisionn values like below and in the first expression current date selection and second expression from month start to current date(suppose if we select Nov 25 in the second exp should be display 1-Nov-2014 to 25-Nov-2014 data ).

Header 1	Header 2	Header 3	Header 4
Division	Sector	Sum (ales) at current date(i mean current selection)	sum(sales) From-monthstart - Currentdate selection
XY areoplanespears		Values	Values
XY autospears		Values	Values
XY domestic		Values	Values
XY international		Values	Values
XY unitdivision		Values	Values
XY all(areoplanespears, international)		Values	Values
YZ all(unitdivision)		Values	Values

XY all means what are the Division values is related to XY sector those need to display like YZ also.

In the First exp we have to display the current selection value and second expression from month starting to currentselection data only.

Please give any suggsion,

Please find the attachments .

Thanks in advance

Re: how to create the value using existed value

ravindraa — Tue, 25 Nov 2014 12:42:17 GMT

Hi experts,

Please give me any suggesion.

Thanks in advance.

Thanks

Ravindra

Re: how to create the value using existed value

Tue, 25 Nov 2014 15:36:13 GMT

Hi,

Please find the attached Solution to your Problem...

Hope it Helps !

Cheers !

Re: how to create the value using existed value

ravindraa — Wed, 26 Nov 2014 04:54:34 GMT

HI Prinyanka,

Thanks for replying but in stright table Division field need to be maintain one extra value that XYALL like areoplanespears,Gio Spares...etc XYALL field comeing from after combin the international and areoplanespears values because international and areoplanespears these values sector is XY.

Please give me any suggesion.

Thansk in advance

Re: Re: how to create the value using existed value

Wed, 26 Nov 2014 15:45:41 GMT

Hi,

Not sure If u can have those two Rows in the same Chart, however I have created the same ina second Chart.

Hope it helps.

Chees !