Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Show column values conditionally?

Hi,

I have a data table which shows monthly sales in a grid, i.e. 12 columns, plus a total in 13th column.

Using set analysis, it correctly shows the total of the selected months, e.g  when Jan, Feb selected it will only show Jan+Feb numbers, however other months' figures are still displayed in the grid, which is confusing / wrong to look at.

What syntax would I use to have the 'unselected' months show a blank column?

Jan expression is : Sum({$<[FiscalPeriodText]={'3~January'}>}ExtPrice)

Feb expression is : Sum({$<[FiscalPeriodText]={'4~February'}>}ExtPrice)

Total expression is: Sum(ExtPrice)

Screen shot attached.

(3 and 4 are our fiscal month numbers).

thanks.

7 Replies
Partner
Partner

Hi,

Why don't you make a pivot with the months as columns, thereby having the selections will referenced in the columns showing as you intend? It also has an automatic 'total' function.

Creator
Creator

Thanks for your reply. I was hoping this could be done without a pivot, but perhaps not.....

I'm now trying this, however, I can't see how to get the yearly total on the right most column and also the total at the top of each column for all sales for a give month (easy in a normal table but can't see how to in pivot)

Stephen

Master III
Master III

Do you get the filters to work if you disable the total expression?

Specialist III
Specialist III

Hi,

can you try JSPivotTable Extension.

Qlik Sense - Pivot Table Extension

Use Month also as Dimension and One Expression for all the Months.

297072.PNG

Creator
Creator

No, I'm afraid this didn't make a difference, thanks for your reply

Creator
Creator

Thanks for your reply. I will certainly look at this, but I'm new to Qlik and haven't done anything with extension. I think I may be unable to as I'm using Qlik Cloud (Business), rather than having it installed on my PC.

Thanks.

Creator
Creator

I have found how to get row total (albeit it's on the left hand side) but not at the top, yet. Thanks again.