topic help needed with set analysis in line chart in QlikView

help needed with set analysis in line chart

fashid — Fri, 14 Nov 2014 10:40:36 GMT

Hi,

I am trying to implement a set analysis expression in a line chart which is same as the expression in my gauge chart

The problem is that I want the dimensions to be day but i am unable to get the proper values in the line chart .

The expression works with the gauge chart .!!!

For eg if the gauge chart shows C.E. for a particular day is 80% the same should be shown by the line chart including all other days .

the dimension should be restricted to day only .

What could be done in order to get this working .

I am also attaching my QVW app for reference.

Re: help needed with set analysis in line chart

Fri, 14 Nov 2014 11:08:40 GMT

Hi Nadeem,

Try this expression in your line chart:

=(sum({<[MARA.Material Type_MTART]={'HALB'}>}[VEKP.Loading volume_NTVOL])/(sum([Glass Melt]*$(vnoofdaysincrement))))

And set number format for the same is as below:

Let me know is this is what you are looking for.

Regards,

Vidit Desai

Re: help needed with set analysis in line chart

fashid — Fri, 14 Nov 2014 11:16:37 GMT

Hi,

Thanks for taking your time to reply

it does not work can u send me a screenshot if you implemented in the sample app

Regards,

Nadeem

Re: help needed with set analysis in line chart

Fri, 14 Nov 2014 11:26:16 GMT

Is this what you want?

Re: help needed with set analysis in line chart

PradeepReddy — Fri, 14 Nov 2014 11:27:36 GMT

I think it might be not possible.. what you are looking for..

Re: help needed with set analysis in line chart

fashid — Fri, 14 Nov 2014 11:37:51 GMT

Nope the CE should come day wise if i select a particular month

Re: help needed with set analysis in line chart

fashid — Fri, 14 Nov 2014 11:38:33 GMT

can i implement the CE formula in the backend

Re: help needed with set analysis in line chart

fashid — Fri, 14 Nov 2014 11:54:13 GMT

HI,

I used this

=sum({<[MARA.Material Type_MTART]={'HALB'}>}[VEKP.Loading volume_NTVOL])/[Glass Melt]

as the no of days are already present as dimension in the chart we dont need to multiply the glass melt with the no of days !

Re: help needed with set analysis in line chart

Fri, 14 Nov 2014 13:50:07 GMT

Hi,

Please try below formula in your expression:

=(sum({$<Day=>}if([MARA.Material Type_MTART]='HALB',[VEKP.Loading volume_NTVOL]))/

(avg({<year=,month=>}[Glass Melt])))

You will get above chart for the month of Oct, i think this would achieve your requirement.