topic Re: Is it Possible to create Static Straight Table with custom sorting for a dimension in QlikView

Is it Possible to create Static Straight Table with custom sorting for a dimension

yenumulagopi — Tue, 05 Jun 2018 07:44:13 GMT

Hi All,

I have a Straight Table like in below image. And I have made a custom sorting for the Dimension as per the requirement and custom Background Color also for some field names.

Question : If I make the selections, some field names in Product Group (rows) are hiding and the Custom Background Color also disappearing for one or two field names. But as per the requirement, I need to show all the field names of Product Group in the order even if there is a selection.

Is it possible to show all the dimension names with custom sorting and with custom background color without any change for the Straight table?

Can you please help me to resolve this issue.

Thanks in advance

Re: Is it Possible to create Static Straight Table with custom sorting for a dimension

sunny_talwar — Tue, 05 Jun 2018 11:26:18 GMT

What are you expressions? Are you ignoring selections in all fields? Would you be able to share a sample document to show the issue?

Re: Is it Possible to create Static Straight Table with custom sorting for a dimension

dsharmaqv — Tue, 05 Jun 2018 11:29:52 GMT

Could you please share the app/experssion.

Re: Is it Possible to create Static Straight Table with custom sorting for a dimension

yenumulagopi — Tue, 05 Jun 2018 11:53:33 GMT

Hi Deepak,

Thanks for looking in this. Please find the below expression which is used in the Straight table.

Sum({$<Year={$(=Max(Year))}>} Sales / $(vCurrency))

When we started selecting the Year and Month some rows are hiding.

Re: Is it Possible to create Static Straight Table with custom sorting for a dimension

sunny_talwar — Tue, 05 Jun 2018 11:58:22 GMT

May be try this

Sum({$<Year={$(=Max({1} Year))}, Month>} Sales / $(vCurrency))

Re: Is it Possible to create Static Straight Table with custom sorting for a dimension

yenumulagopi — Wed, 06 Jun 2018 03:52:49 GMT

Hi Sunny,

Thanks for your reply.

I have tried the above, it's not working. In my Straight table, there are MTD, YTD and Last year MTD, YTD's are there.

Please find the below exp. which is used.

MTD:

=Sum({<Year=,Month=,Year={$(=max(Year))}, MonthNum={$(=max({<Year={$(=max(Year))}>}MonthNum))}>}Sales)

YTD:

=Sum({<Year=,Month=,Year={$(=max(Year))}, MonthNum={'<=$(=max({<Year=$(=max(Year))}>}MonthNum))'}>}Sales)

Thanks in advance.

Re: Is it Possible to create Static Straight Table with custom sorting for a dimension

sunny_talwar — Wed, 06 Jun 2018 15:21:24 GMT

Try this

MTD:

=Sum({<Year = {$(=Max({1}Year))}, MonthNum = {$(=Max({1<Year={$(=Max({1}Year))}>} MonthNum))}>} Sales)

YTD:

=Sum({<Year = {$(=Max({1}Year))}, MonthNum = {'<=$(=Max({1<Year = $(=Max({1} Year))}>} MonthNum))'}>} Sales)

Re: Is it Possible to create Static Straight Table with custom sorting for a dimension

yenumulagopi — Thu, 07 Jun 2018 04:11:30 GMT

Hi Sunny,

Thanks for your reply. I have tried this but it's not resolved.

Anyway, I have found the solution for this. I have taken the Sum(Sales) as additional column, so that I can get total Sales for each and every row of the dimension and then I have hide the column in properties. Now it's showing all the rows without hiding and in the order of custom sorting.

Thanks

Gopi

Re: Is it Possible to create Static Straight Table with custom sorting for a dimension

sunny_talwar — Thu, 07 Jun 2018 15:25:04 GMT

Somehow it is very strange, but okay