Can We use the output of created table in qlikview as dimension in Grid Chart.

[#1]

HI all,

Can I use the output of a table which i created in QlikView as a dimension in a grid chart?

For example: I crated a table with 2 dimensions and a expression labeled as YTD. NOw I wanna use this YTD as a dimension in my grid chart.

You can find the scrambled app in attachements.

In this app , I created a table with certain set analysis expressions . Those expressions output  I should use as dimension for the Grid chart in the mapping sheet.

Any help would be appreciated.

Thanks in advance

Regards,

Susvith

[#2]

Hi Susvith,

You can use any aggregate expression as dimension when  it is being calculated at script level only.

Regards

Nitin

[#3]

Hi nitin,

Thanks for your reply .

In my case I used a set analysis in table level expressions . I dont have any clue about how to get the same output in script level .

Can you help me for this expression?

"

Sum

({$<YEAR = {$(=Max(YEAR))}>} VOLUME)

"
Thanks again.

Regards,

Susvith

[Sokkorn]

Hi Susvith,

Can't understand well on your issue. Can you share your app with manipulate desire result?

Regards,

Sokkorn

[#5]

HI sokkorn,

You can find the attched file now.

Regards,

Susvith

[#6]

Hi Susvith,

Check the Chart captioned "EXAMPLE" ,

Hope it might fulfill your requirement

Regards

Nitin

[#7]

HI nithin,

Thanks for your time bro.

I am still unable to get desired result.

Regards,

Susvith

[#8]

May I know exactly what is your desired output.......