topic Re: Straight Table Chart Expression update in QlikView

Straight Table Chart Expression update

Wed, 06 Jul 2016 21:00:31 GMT

Good day to all and Hope all are well!!!

I have a process that I put in place for calculating YTD balances using an aggregation procedure in the Load.

Now I have, based upon account numbers, a series of calculated YTD balances that are identified as follows:

JanDepsYTDcalc, FebDepsYTDcalc, MarDepsYTDcalc, etc.

In a straight table I can simply exhibit FebDepsYTDcalc and JanDepsYTDcalc and the difference.

I would like to drive the process using a List Box where if I select Feb, it will automatically populate the expression to perform the difference between Feb and Jan.

Please help.

Thanks,

Mitch

Re: Straight Table Chart Expression update

sunny_talwar — Wed, 06 Jul 2016 21:39:43 GMT

Would you be able to provide a sample of what you are trying to do?

Re: Straight Table Chart Expression update

Thu, 07 Jul 2016 12:15:54 GMT

I have a chart (straight table) that looks like this:

Relationship Name Account number MayYTD Deposits AprYTD Deposits Diff between May and April
J&J 23457899 345 310 35

J&J 34120943 250 300 (50)

MayYTD Deposits is derived from an aggregated calculation 'MayDepsYTDcalc'

AprYTD Deposits is derived from an aggregated calculation 'AprDepsYTDcalc'

Diff is 'MayDepsYTDcalc' - 'AprDepsYTDcalc'

I would like to have a List Box that has all the months of the year and if I click on May then the straight table will automatically show the example that I provided.

Thank you

Re: Straight Table Chart Expression update

Anonymous — Thu, 07 Jul 2016 14:54:23 GMT

So you want a Month over previous month comparison starting from YTD. If so this is what we need do you have any YTD flags in your data model. If so provide us that. If not provide us your date field. stalwar1 am i referring correctly here sunny.

Re: Straight Table Chart Expression update

Thu, 07 Jul 2016 17:48:13 GMT

I have a field called, Malpha, which contains the value 'Jan'

In my expression, I want to use Malpha to identify the field name JanDepsYTDcalc

How would that work?

'$(Malpha)'&'DepsYTDcalc'

does not work

Re: Straight Table Chart Expression update

boorgura — Thu, 07 Jul 2016 18:03:28 GMT

if you are trying to arrive at the string --> $() is for evaluating variables not field.

try using only(Malpha)