topic Re: How to categorize expressions? in QlikView

How to categorize expressions?

achates2008 — Wed, 14 Dec 2016 02:52:02 GMT

I have various expressions in the pivot table which are calculated on different time base, therefore I want to categorize them for more readable. It will looks like below. Is it possible to achieve? Thanks!

	current month		YTD
	actual	forecast	actual	forecast
a	10	9	50	45
b	12	15	60	70
c	14	14	55	60

Re: How to categorize expressions?

Gysbert_Wassenaar — Wed, 14 Dec 2016 10:06:47 GMT

therefore I want to categorize them for more readable.

What does that mean? Categorize what in which way? What are the categories?

Re: How to categorize expressions?

swuehl — Wed, 14 Dec 2016 10:34:17 GMT

Maybe just create another dimension, using a stand-alone table in your data model or a synthetic dimension using ValueList('current','YTD'), then check this dimension's current value in your expression and branch into current / YTD evaluation:

=If( ValueList('current','YTD') = 'current',

YouCurrentExpressions,

YourYTDExpressions

)

Re: How to categorize expressions?

achates2008 — Thu, 15 Dec 2016 01:00:19 GMT

Hi Gysbert,

Normally the label of expression will be like current actual, YTD actual, current forecast, YTD forecast, etc. If I can categorize them as the header of the example, it will be clearer for user, right? Or do you have any other suggestion?

Re: How to categorize expressions?

achates2008 — Thu, 15 Dec 2016 01:08:58 GMT

Hi Stefan,

It is not about synthetic dimension. Dimension should be fixed, just the expressions should be put into different category as my example, like what we will do in Excel. You may refer to my reply to Gysbert. Or if you can provide an example it will be better, if my understanding is not accurate.

Re: How to categorize expressions?

Gysbert_Wassenaar — Thu, 15 Dec 2016 06:14:33 GMT

A chart doesn't have Categories, only Dimensions and Expressions. Therefore if you want to create categories you need to create a dimension. A synthetic dimension like swuehl posted above will do the trick.

Re: How to categorize expressions?

achates2008 — Thu, 15 Dec 2016 06:17:39 GMT

ok, I will try . Thank you all for the help!