To fetch the dimension value in the set analysis

[#1]

Hi All,

Please find the attached sample displaying the sum for the different Quarter. In the same attached I have used a inline table for QTR (1,2,3,4) and written the Set Analysis to display this according to the data.  I need to get this quarterInline (used in dimention) to get in the set  analysis so that I can remove hard coding the values.

Note : Due to the existing data model issue we cannot join the Inline QuarterInline to the tables. This is a sample data I have provided. Please let me know if any more information is required.

Thanks,

Sijo Joseph

[swuehl · Accepted solution]

A set expression is evaluated once per chart, so you can't fetch the dimension value in a set expression.

Check this post

http://community.qlik.com/docs/DOC-1335

So your current approach might be the only workaround (or an equivalent pick / match combination).

Hope this helps,

Stefan

[Anonymous]

VERY USEFULL LINK , I WAS SEARCHING THE WAY TO COMPARE TWO FIELDS

OF DATABASE DIRECTLY AND THIS POST HELP ME FINDING THAT

THANK'S SWUEL

[#4]

Thanks