topic Re: Set Analysis on Line Chart in QlikView

Set Analysis on Line Chart

Fri, 17 Jan 2014 16:23:13 GMT

I currently have a line chart that I have applied set anaylyis against the dimension of [Project Name]. I do not want this chart affected by the filter for [Work Entry Year] so I used the following logic, but it is not working. When someone filters against [Work Entry Year] the chart is being filtered.

aggr(only({$<State={"Request"}, [Work Entry Year]>} [Project Name]), [Project Name])

Re: Set Analysis on Line Chart

Anonymous — Fri, 17 Jan 2014 16:26:36 GMT

You need to put = sign after [Work Entry Year] :

aggr(only({$<State={"Request"}, [Work Entry Year]=>} [Project Name]), [Project Name])

Please try and let me know

Yaniv

Re: Set Analysis on Line Chart

Fri, 17 Jan 2014 16:46:37 GMT

I tried adding the = symbol but the chart is still filtered when somone applies the [Work Entry Year] filter.

Re: Set Analysis on Line Chart

Fri, 17 Jan 2014 18:00:26 GMT

any chance the aggr(only()) function is incorrect? i am not sure what other function to use when just measuring a dimension / expression against text values.

Re: Set Analysis on Line Chart

Fri, 17 Jan 2014 18:40:50 GMT

As a workaround, until i can figure out the dimension logic i used the alternate state functionality.

I added a new state "alt1" to my document properties and then pointed the chart to this state whereas the rest are using <inherited state>

Re: Set Analysis on Line Chart

Nicole-Smith — Fri, 17 Jan 2014 18:49:40 GMT

Just adding the equal sign should work. I don't think you want to go the alternate states route because that adds a lot more complexity that you don't need.

Please post a sample .qvw and we can help you: Preparing examples for Upload - Reduction and Data Scrambling

Re: Set Analysis on Line Chart

Fri, 17 Jan 2014 18:59:41 GMT

For some reason, the = sign did not work.

I will send over a sample .QVW file, not sure if I will get to that today though.

Thanks for following up.

Re: Set Analysis on Line Chart

jpapador — Fri, 17 Jan 2014 19:59:45 GMT

What do you want your final output to look like?

Re: Set Analysis on Line Chart

kiranmanoharrode — Fri, 17 Jan 2014 20:01:11 GMT

try below expression

=only(aggr(only({$<State={"Request"}, [Work Entry Year]=>} [Project Name]), [Project Name]))

Re: Set Analysis on Line Chart

Anonymous — Fri, 17 Jan 2014 20:23:00 GMT

Steve,

To make chart independent from the field selection, you have to use this

{< [Work Entry Year]=>}

in chart expression. In all expressions if you have multiple. As I understand, you're using it in calculated dimension now.

Regards,

Michael

Re: Set Analysis on Line Chart

Nicole-Smith — Fri, 17 Jan 2014 20:24:47 GMT

Good call Michael Solomovich! I completely missed that little detail.

Re: Set Analysis on Line Chart

Fri, 17 Jan 2014 20:31:02 GMT

Yes, I am using a calculated dimension.

My current expression looks like this (see below). Where would I add the {<[Work Entry Year]>} logic?

if([Front Door Status] = 'New', 1, if(Match([Front Door Status], 'Needs Reqs', 'Needs Design', 'Product Review'), 2, if([Front Door Status] = 'Approved for Estimate', 3, if([Front Door Status] = 'Estimating', 4, if([Front Door Status] = 'Estimated', 5,

if([Front Door Status] = 'Committed', 6, if([Front Door Status] = 'Approved', 7, if([Front Door Status] = 'Cancelled', 8, if([Front Door Status] = 'On Hold', 9)))))))))

Re: Set Analysis on Line Chart

Anonymous — Fri, 17 Jan 2014 20:40:27 GMT

Try this (I just tested with a similar expression, it worked):

only( {<[Work Entry Year]>} <your long expression here>)

If it doesn't help, upload your file.

Re: Set Analysis on Line Chart

Fri, 17 Jan 2014 20:51:36 GMT

that worked, thanks everyone for your helped