topic Re: Pivot table vs. expression (set analysis) in QlikView

Pivot table vs. expression (set analysis)

Anonymous — Mon, 27 Feb 2017 11:00:39 GMT

Hi all,

I hope someone can help.

Below an example dataset:

Now, i want to use an pivot table with the folowing functionality:

When i select no months the pivot table must show

When i select month 1 the pivot table must show

Best regards,

Arjan

sunny_talwar — Mon, 27 Feb 2017 11:07:49 GMT

May be like this

Dimensions

Customer

Year

Expression

FirstSortedValue(Value, -MonthNum)

sunny_talwar — Mon, 27 Feb 2017 11:09:45 GMT

Sample qvw attached

Anonymous — Mon, 27 Feb 2017 14:23:15 GMT

Hi Sunny,

Thanks for your respons. Its almost right!

I have in de dataset more records for the same period and customer. Then it is not working.

Do I need to putt a sum in the expression?

Best regards,

Arjan

sunny_talwar — Mon, 27 Feb 2017 14:34:22 GMT

Try this:

FirstSortedValue(Aggr(Sum(Value), Customer, Year, MonthNum), -MonthNum)

FirstSortedValue(Aggr(Sum(Value), Customer, Year, MonthNum), -Aggr(MonthNum, Customer, Year, MonthNum))