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

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

Mon, 11 Nov 2013 06:49:25 GMT

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

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

Mon, 11 Nov 2013 06:53:01 GMT

Hi Susvith,

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

Regards

Nitin

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

Mon, 11 Nov 2013 07:01:38 GMT

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

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

Sokkorn — Mon, 11 Nov 2013 08:21:38 GMT

Hi Susvith,

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

Regards,

Sokkorn

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

Mon, 11 Nov 2013 08:38:46 GMT

HI sokkorn,

You can find the attched file now.

Regards,

Susvith

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

Mon, 11 Nov 2013 09:07:03 GMT

Hi Susvith,

Check the Chart captioned "EXAMPLE" ,

Hope it might fulfill your requirement

Regards

Nitin

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

Mon, 11 Nov 2013 09:41:54 GMT

HI nithin,

Thanks for your time bro.

I am still unable to get desired result.

Regards,

Susvith

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

Mon, 11 Nov 2013 10:06:05 GMT

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