Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stephenhasson
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
niclaz79
Partner - Creator III
Partner - Creator III

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.

stephenhasson
Creator
Creator
Author

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

sasiparupudi1
Master III
Master III

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

mdmukramali
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

stephenhasson
Creator
Creator
Author

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

stephenhasson
Creator
Creator
Author

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.

stephenhasson
Creator
Creator
Author

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