topic Re: Help with a chart expressions in QlikView

Help with a chart expressions

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

All

I need help with a expression on line chart. I want to show "=[Metric(Result)]" and need to select the following to show only those criteria's in the chart.

However I can't seem to and having errors as soon I use this =({<[Metric(Result)],IGA = {'UK_35'},[Service ID]={'PCEN06'},[SLA ID]= {'SL01.UK.BI'}>})

Can you please let me know where I am going wrong.

Thanks

Mohi

Re: Help with a chart expressions

sudhakar_budde — Wed, 17 Oct 2018 12:53:34 GMT

Hi Mohiuddin,

I guess you are trying to perform a Set Analysis, if so try similar expression as below:

SUM({$<IGA = {'UK_35'}, [Service ID]={'PCEN06'}, [SLA ID]= {'SL01.UK.BI'}>} [Metric(Result)])

You can always refer to the help here:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/SetAnalysis/set-analysis-expr…

Can you please post your question with more details next time?

Hope this helps you...

Regards

Re: Help with a chart expressions

kfoudhaily — Wed, 17 Oct 2018 12:56:07 GMT

hello, I think you're not providing enough information to be able to respond correctly to your request.

what does the expression "[Metric(Result)]" stands for?

is it the metric in your fact table?

where is your aggregation expression?

Re: Help with a chart expressions

mohiahmed — Wed, 17 Oct 2018 13:09:00 GMT

Hi,

In the table I have the data in the format below

IGA Service ID SLA ID Metrics Result Month

UK_35 PCEN06 SL01.UK.BI 95% 01/04/2018

UK_36 PCEN07 SL02.UK.BI 97% 01/05/2018

Re: Help with a chart expressions

mohiahmed — Wed, 17 Oct 2018 13:11:41 GMT

Many thanks for this, however it's not a sum as data is aggregated hence using the "=[Metric(Result)]".

Data structure is similar to below

IGA Service ID SLA ID Metrics Result Month

UK_35 PCEN06 SL01.UK.BI 95% 01/04/2018

UK_36 PCEN07 SL02.UK.BI 97% 01/05/2018

UK_37 PCEN08 SL03.UK.BI 95% 01/04/2018

UK_36 PCEN09 SL04.UK.BI 97% 01/05/2018

Re: Help with a chart expressions

stigchel — Wed, 17 Oct 2018 13:30:01 GMT

You still need a function that will take set analysis, something like this

=Only({<[Metric(Result)],IGA = {'UK_35'},[Service ID]={'PCEN06'},[SLA ID]= {'SL01.UK.BI'}>})

It’s all Aggregations

Re: Help with a chart expressions

mohiahmed — Wed, 17 Oct 2018 13:43:50 GMT

Hi, Many thanks for suggesting the only function, however when i use "Only ([Metric(Result)])" it seems fine, however when I use =Only({<[Metric(Result)],IGA = {'UK_35'},[Service ID]={'PCEN06'},[SLA ID]= {'SL01.UK.BI'}>}) it gives me an error.

Re: Help with a chart expressions

Anil_Babu_Samineni — Wed, 17 Oct 2018 13:50:00 GMT

What dimension bases you are using Only() function, You need one dimension there?

Re: Help with a chart expressions

stigchel — Wed, 17 Oct 2018 14:01:15 GMT

Sorry, I copied the expression too fast, it's missing the field

Only({<IGA = {'UK_35'},[Service ID]={'PCEN06'},[SLA ID]= {'SL01.UK.BI'}>} [Metric(Result)])

Re: Help with a chart expressions

mohiahmed — Wed, 17 Oct 2018 14:01:33 GMT

I have used months as dimention