Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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


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

7 Replies
Not applicable
Author

Hi Susvith,

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

Regards

Nitin

Not applicable
Author

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
Master
Master

Hi Susvith,

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

Regards,

Sokkorn

Not applicable
Author

HI sokkorn,

You can find the attched file now.

Regards,

Susvith

Not applicable
Author

Hi Susvith,

Check the Chart captioned "EXAMPLE" ,

Hope it might fulfill your requirement

Regards

Nitin

Not applicable
Author


HI nithin,

Thanks for your time bro.

I am still unable to get desired result.

Regards,

Susvith

Not applicable
Author

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