topic Re: Qlikview setanalysis without using aggregation function in QlikView

Qlikview setanalysis without using aggregation function

Thu, 21 Jan 2016 12:15:47 GMT

Hi,

I dont want to consider month selection while using chart and does not require to use aggregation at caluclation.

I have written following setanalysis caluclation

=If(Aggr='R',only({<Month=>}($(vMed))),only({<Month=>}($(vMed))))

This is working fine and all results are coming correct.

however i have written an experssion at dimension level to show back ground colour and text colour in bold format, this is not working after using Month in setanalysis.

Can you guys throw some insight on this ?

Regards,

Re: Qlikview setanalysis without using aggregation function

Gysbert_Wassenaar — Sat, 23 Jan 2016 14:10:20 GMT

=If(Aggr='R',

only({<Month=>}($(vMed))),

only({<Month=>}($(vMed)))

)

Both branches of your if statement are the same. And both branches have a closing parenthesis without a matching opening one. Your expression cannot work (unless your variable vMed contains an opening parenthesis).

I don't understand your problem. Perhaps you can post a small qlikview document that illustrates the problem.

Re: Qlikview setanalysis without using aggregation function

Sat, 23 Jan 2016 15:44:00 GMT

Hi Gysbert,

Thanks for your reply.

Sorry did not mention formula correctly

Now the correct one is

=If(Aggr='R',

only({<Month=>}($(vMed))),

only({<Month=>}($(vMedia)))

)

and this is working.

The only reason is we are getting data from excel and it has already calulcations done and iam showing that data in chart without any aggregation using setanalysis.

The chart shouldnot change when specific month selection is done,It need to display the chart for whole year.

With this formulae its working fine however the bold format for dimension and back ground is not working due to "only" in caluclation level.

At the dimension level i have wrriten following for back ground colour

If(match(format,'H','B'),rgb(210,210,210)) and

text format

If(match(format,'H','B'),'<B>')

The earlier formulae where its working for back ground and text format is

=IF(AGGR='R',($(vMedida)),($(vMedida_SinRollup))) however its showing chart for specific month selection and we want to exclude month and show whole year without effecting month selection

If(Aggr='R',

only({<Month=>}($(vMed))),

only({<Month=>}($(vMedia)))

)

Regards,

Ram

Re: Qlikview setanalysis without using aggregation function

Gysbert_Wassenaar — Sat, 23 Jan 2016 15:53:35 GMT

Try replacing Aggr with only({<Month=>}Aggr)

Re: Qlikview setanalysis without using aggregation function

Tue, 26 Jan 2016 11:19:28 GMT

Hi,

It didn't work.

I made a slight modification to the dimension related to back ground and bold

=only({<Month=>}if(Match(FORMAT,'H','B'),rgb(210,210,210)))

=only({<Month=>}if(Match(FORMAT,'H','B'),'<B>'))

This worked.

Thanks a lot for your help.

Regards,

Ram