Table help

Anonymous — Mon, 29 Dec 2014 20:41:41 GMT

Hello,

Looking for some help to correct a table. Originally I was using YTD data, and using set analysis to lock onto one month. After a change from the users, I have been given MTD data. I am no longer using Month in my set analysis, but I would like the current month if no selection to show under month. If a month is selected, I would like that to show, with the data showing YTD through that month.

Is this possible?

Here is a picture of the table:

Since I am using Dimensionality as a way to show the variance below, I need a way to create different rows. Another way to create variance below the sales of the month would be fine as well.

Here is a sample of the code:

if ( Dimensionality()=0,
((sum({<[NEW RENEW IND]={'COMBINED'}, YEAR={$(vBusinessYear)}>}[SALES])/1000000)-
(sum({<[NEW RENEW IND]={'COMBINED'}, YEAR={'PLAN'}>}[SALES])/1000000)),
sum({<[NEW RENEW IND]={'COMBINED'}, YEAR={'PLAN'}>}[SALES])/1000000)

Thank you for the help,

Justin

topic Table help in QlikView

Table help