topic v8.2 problem with table in QlikView

v8.2 problem with table

avastani — Fri, 11 Dec 2009 00:35:35 GMT

How can I have a chart expression ignore the values selected in a dimension and provide results. I can do this in set analysis, but looking to do it without since 8.2 doesn't have set analysis.

Is it possible?

v8.2 problem with table

sathishkumar_go — Fri, 11 Dec 2009 02:08:22 GMT

Hi Amir,

I think 8.2 is possible for set analysis.

in 8.5 we use setanalysis All

in 8.2 just try this {}

-Sathish

v8.2 problem with table

avastani — Fri, 11 Dec 2009 03:10:32 GMT

didnt work, in 8.2, can you please share what you did?

v8.2 problem with table

Fri, 11 Dec 2009 03:51:04 GMT

Set analisys was first introduced in 8.5

v8.2 problem with table

avastani — Fri, 11 Dec 2009 04:04:02 GMT

that's what i thought too. hence my question if we can ignore a dimension in the expression for a table chart.

is it possible?

v8.2 problem with table

Fri, 11 Dec 2009 04:11:09 GMT

Use "ALL":

sum(ALL Amount)

and combine it with IF():

sum(ALL if(Town = 'Atlanta', Amount) )

v8.2 problem with table

avastani — Fri, 11 Dec 2009 04:15:10 GMT

so if i want to make it dynamic and ignore the Town dimension but consider all other dimensions, then

SUM(ALL if(Town=, Amount))

would do it?

v8.2 problem with table

Fri, 11 Dec 2009 04:30:17 GMT

nope.

That's a SET ANALISYS feature. Why don't you upgrade?

v8.2 problem with table

avastani — Fri, 11 Dec 2009 04:48:33 GMT

that's the limitation. how can i make it happen in 8.2 is the challenge. i know it is possible but i can't nail it to the syntax