topic Re: Logic correction in QlikView

Logic correction

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

Hi,

I have used the below logic in calculated dimension.But i'm getting common value to all the dimensions.

Please find below for reference.

Logic:

=aggr(num((sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>} Sales))

/(sum({<Date={$(varMaxDate)},flag={'Wet Sign'}>} Sales)+sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>} Sales)

+sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>} Sales)),' #,##0.0%'),Loc)

Thanks..

Re: Logic correction

MK_QSL — Mon, 16 Jan 2017 15:03:59 GMT

Try this...

num(

(sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>}Sales))

(

sum({<Date={$(varMaxDate)},flag={'Wet Sign'}>} Sales)

sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>}Sales)

sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales)

)

,' #,##0.0%')

Re: Logic correction

MK_QSL — Mon, 16 Jan 2017 15:05:42 GMT

or this

num(

(sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>}Sales))

(

sum(TOTAL <Loc> {<Date={$(varMaxDate)},flag={'Wet Sign'}>}Sales)

sum(TOTAL <Loc> {<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>}Sales)

sum(TOTAL <Loc> {<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales)

)

,' #,##0.0%')

Re: Logic correction

nareshthavidishetty — Mon, 16 Jan 2017 15:32:52 GMT

Hi ,

I have used both the logic's as dimension.

I'm getting Below error.

Thanks..

Re: Logic correction

nareshthavidishetty — Mon, 16 Jan 2017 16:31:39 GMT

Hi,

Please let me know how to get this.

Thanks..

Re: Logic correction

MK_QSL — Mon, 16 Jan 2017 17:04:07 GMT

Provide sample application or sample data.

Re: Logic correction

MK9885 — Mon, 16 Jan 2017 18:30:56 GMT

num(

sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>}Sales))

sum(TOTAL <Loc> {<Date={$(varMaxDate)},flag={'Wet Sign','eSign'},Category={'Complete','Not Complete'}>}Sales)

,' #,##0.0%')

???

Maybe this?

Not sure if the syntax is correct but you can check it out.