topic Re: Straight table issue in App Development

Straight table issue

Fri, 08 Jul 2016 13:29:23 GMT

I am using Qliksense

Attached please find the sample data, sample qvw and screen shot. I have a Year and Launch Year fields. So In each Year I can have multiple Launch Years, for example Year=2016 will have launch Years 2016,2015,2014 etc

for Year 2015 will have launch Years 2016,2015,2014 etc.

Now I want to use the following grouping:

=If(LaunchYear >= Year,'<1 Year',

If(LaunchYear >= (Year-2) and LaunchYear < Year,'Prior 2 Years',

If(LaunchYear <= (Year-3), 'Prior 3 Year')))

But at the same time I want to exclude any future Launch Years. For example , If I am in Year 2015, I want to see only Launch Years <= 2015 and then in the last column I would to sum the total for each Year.

Looking for the solution

Re: Straight table issue

sunny_talwar — Fri, 08 Jul 2016 14:57:15 GMT

Try this:

=If(LaunchYear = Year,'<1 Year',

If(LaunchYear >= (Year-2) and LaunchYear < Year,'Prior 2 Years',

If(LaunchYear <= (Year-3), 'Prior 3 Year')))

Removed the greater than sign here (=If(LaunchYear >= Year,'<1 Year',)

also selected 'Suppress When Value Is Null'

Re: Straight table issue

Fri, 08 Jul 2016 15:03:48 GMT

I am using Qlik Sense

Re: Straight table issue

Fri, 08 Jul 2016 15:06:12 GMT

Also the total is not working. Total should be the same for all rows for Year 2016, 2015 and 2014

Re: Straight table issue

sunny_talwar — Fri, 08 Jul 2016 15:13:00 GMT

Why did you post a QlikView sample? Can you post a QlikSense sample to check the issue?

Re: Straight table issue

Fri, 08 Jul 2016 15:13:52 GMT

Let me do that then

Re: Straight table issue

Fri, 08 Jul 2016 15:23:03 GMT

Attached is the sample QVF

Re: Straight table issue

sunny_talwar — Fri, 08 Jul 2016 15:55:13 GMT

This?

What is wrong with the total? What do you want to see?

Re: Straight table issue

Fri, 08 Jul 2016 16:09:56 GMT

The sample qvf you sent works, but when I amsuing the same info on the actual data set the total is nor working. I am getting the total for the dimension Launch condition.

My expression for total is

Sum( total <Year> SPLTQTY)

What am I missing here?

Re: Straight table issue

sunny_talwar — Fri, 08 Jul 2016 16:25:27 GMT

Can you try this:

Aggr(NODISTINCT Sum(SPLTQTY), Year)

Re: Straight table issue

Fri, 08 Jul 2016 18:22:16 GMT

This does give me the sum at the Year level , but the sum is not right. If you sum the Values in the Volume column for the Year they dont add up to the total value

Re: Straight table issue

sunny_talwar — Fri, 08 Jul 2016 18:54:43 GMT

Cannot test this, but how about this:

Aggr(NODISTINCT Sum(If(LaunchYear < Year, SPLTQTY)), Year)

Re: Straight table issue

Fri, 08 Jul 2016 19:08:57 GMT

Nopes doesnt work