topic Re: Excluding dimension over expressions in QlikView

Excluding dimension over expressions

djallelsadki — Wed, 10 Dec 2014 16:08:34 GMT

Hi,

If any one can help

I have a combo chart with two dimension ( Time and an another one ) and two expressions

the second expression should only be related to the time dimension but not to the second one

I don't know if i'm clear or not !

Thanks,

D.Sadki

Re: Excluding dimension over expressions

yduval75 — Wed, 10 Dec 2014 16:11:49 GMT

For example if your second expression is country,

you have to put in your second expression to don't take into account country

Sum({<Country=>} Sales)

Re: Excluding dimension over expressions

francoiscave — Wed, 10 Dec 2014 16:13:45 GMT

Hi Djallel,

Can you post an application with some test data and your chart? And if is possible your expected result.

It will be useful to resolve your issue.

Best Regards,

François

Re: Excluding dimension over expressions

djallelsadki — Wed, 10 Dec 2014 16:16:11 GMT

Hi,

thanks for your answer, but i tried this and it's not working,

this is my first graph

if i add a second dimension witch contain 3 values, i get this :

what i want is only 3 lines and only one bar on each day

Thanks

D.Sadki

Re: Excluding dimension over expressions

stigchel — Wed, 10 Dec 2014 16:21:17 GMT

You can use the TOTAL key word to bypass dimensions so e.g.

Sum(TOTAL <YourDimension> Sales)

Re: Excluding dimension over expressions

djallelsadki — Wed, 10 Dec 2014 16:27:52 GMT

not working

thanks

Re: Excluding dimension over expressions

stigchel — Wed, 10 Dec 2014 16:39:22 GMT

Did you use the correct dimension within the < >, it should be your first time dimension

Sum(TOTAL <Time> Sales)

Re: Excluding dimension over expressions

djallelsadki — Wed, 10 Dec 2014 16:43:54 GMT

yes

i get that

maybe the problem is on the first expression !

thanks,

D.sadki

Re: Excluding dimension over expressions

djallelsadki — Wed, 10 Dec 2014 16:53:12 GMT

what i need

n ( number of values in the second dimension) lines for the first expression

and only one bar for the second expression

i will try to post an application...

thanks,

D.Sadki

Re: Excluding dimension over expressions

djallelsadki — Wed, 10 Dec 2014 17:04:41 GMT

i post a qvw document

thanks for your help

D.Sadki !

Re: Excluding dimension over expressions

stigchel — Wed, 10 Dec 2014 17:27:45 GMT

See attached, I removed the dimension and copied the expression for the different types.

Re: Excluding dimension over expressions

Anonymous — Wed, 10 Dec 2014 17:36:50 GMT

if i understand your requirement right, the attached document should work. See second chart in Sheet1.

Re: Excluding dimension over expressions

djallelsadki — Wed, 10 Dec 2014 18:48:14 GMT

Hi,

I have already tried this solution , the fact is i have Potentially 3 to 8 kpi and i can not create 8 Expression One For Each of my dimension values and i will have two more dimensions witch are used with conditional visiblity

3 dimension and maybe 8 expressions max, so 24 expression

difficult to maintain

mybe impossible

thanks,

D.Sadki

Re: Excluding dimension over expressions

Anonymous — Wed, 10 Dec 2014 21:10:20 GMT

aah....i understand.

when i have a large number of expressions that i think will be difficult to maintain, i put them in an excel spreadsheet and read them into my app...may be worth a try in your case.

Re: Excluding dimension over expressions

Anonymous — Wed, 10 Dec 2014 21:19:23 GMT

may be this is an alternative...see Sheet1 in attachment. now, there are two options -

1. have 8 expressions in each of the two charts. - easiest to implement and shouldn't be too hard to maintain.

2. create a table with expression name and the actual expression in excel and read it in. then have a list box for expression name and you can update the two charts to display one expression at a time. easier to maintain.

edit: upon additional thought, i think option 1 is better as option to will need you to get a little creative.

Re: Excluding dimension over expressions

djallelsadki — Thu, 11 Dec 2014 08:40:19 GMT

Hi,

ok, i know this method

i will combine this with a script to create each expression

the expressions are similar sum({<kpi={'x'}>}Id), the difficulty reside in the creation of those expressions !

i will have different customers and i'll not create an excel document for each one of them...

maybe with a macro, create each expression and the conditions linked to them

or more simple two graphics, but i need to explain that to my customer

thanks,

D.Sadki

Re: Excluding dimension over expressions

Anonymous — Thu, 11 Dec 2014 14:19:36 GMT

i agree...i find that explaining/educating a customer helps out quite a bit as he may not have thought of this approach. good luck.