topic Re: Using a calculated expression as a dimension in QlikView

Using a calculated expression as a dimension

nburton78 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I'm working on a beast of a report. Basically it takes a list of orders and then it assigns a reason based off the attributes that are pulled from all over the place. I put everything in a Straight table and calculated the "Detail" column with an expression. Now I would like to be able to chart those reasons listed in the "Detail" column and I have no idea if its possible. I'd like to be able to count how many orders have each reason assigned. Any ideas??

this is a very simplified version of the report:

order	attribute1	attribute 2	attribute 3	attribute 4	Detail
a	red	1	yes	10	Reason 1
b	blue	2	yes	9
c	green	3	yes	8
d	yellow	1	no	7
e	red	2	no	6
f	blue	3	no	5

The Detail is set by a formula that looks like "if(attribute1=red and attribute 2 = 3 then detail = Reason 1 else if….Reason 2…."

Re: Using a calculated expression as a dimension

vamsee — Thu, 20 Sep 2018 19:03:51 GMT

If you use the same expression for Detail and create a calculated dimension, what is the error you have?

Re: Using a calculated expression as a dimension

nburton78 — Thu, 20 Sep 2018 19:20:06 GMT

that would be perfect except some of the attributes are expressions also. I could move the expressions to calculated dimensions if I can I refer to a calculated dimension?

Re: Using a calculated expression as a dimension

vamsee — Thu, 20 Sep 2018 20:50:09 GMT

Ohh..try that if you can. I would suggest the best way go ahead is to do your data modelling at the script level.

So, multiple residents and joins should so give you an aggregated table with the detail and attributes as fields.

If you can post you QVW with script & (sample or scrambled data, I can be more specific.