Help with a chart expressions

[mohiahmed]

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

[sudhakar_budde]

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/SetAnalys...

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

Hope this helps you...

Regards

SB

[kfoudhaily]

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?

[mohiahmed]

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

[mohiahmed]

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

[stigchel]

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

[mohiahmed]

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. 

[Anil_Babu_Samineni]

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

[stigchel · Accepted solution]

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)])

[mohiahmed]

I have used months as dimention