Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Not able to non-aggregate the value at different dimensions in straight table

Hi All,

I am facing an issue in straight table while adding up the previous YTD value with current monthly value. I find out the value but not able non aggregate at different dimension level. I am attaching the source screen shot  and expected output  screen shot Please help me to achieve this issue it is urgent.

Any help will be appreciated !

Thanks deepak

7 Replies
MVP
MVP

Re: Not able to non-aggregate the value at different dimensions in straight table

What if you remove CODE as dimension?

Not applicable

Re: Not able to non-aggregate the value at different dimensions in straight table

Hi tresesco,

It add both the values of MTD and YTD columns if I removed Code from the table.but I want  to add the value only of MTD column means I want to aggregate ONLY MTD values not YTD .Please find the attached screenshot for your reference.

MVP
MVP

Re: Not able to non-aggregate the value at different dimensions in straight table

Try expression for MTD something like:

Sum(Total <Category> YourMeasure)

Not applicable

Re: Not able to non-aggregate the value at different dimensions in straight table

I tried Not worked.

MVP
MVP

Re: Not able to non-aggregate the value at different dimensions in straight table

Try to share a sample qvw to work on.

Not applicable

Re: Not able to non-aggregate the value at different dimensions in straight table

Hi,

Please find attached sample file.

Regards

deepak

Not applicable

Re: Not able to non-aggregate the value at different dimensions in straight table

Hi Tresesco,

Please reply its urgent.

Thanks,

deepak