Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bhaveshp90
Contributor III

How to fix the table static?

Hello, 

I have a simple straight table as shown below; 

1.PNG

I want to make this table static irrespective of the Data field that is selected in my sheet. 

Do I need to create a new alternate state so that it doesn't change with the selected fields in the sheet?

 

thanks

Bhavesh

Labels (2)
2 Solutions

Accepted Solutions
jensmunnichs
Contributor III

Re: How to fix the table static?

What is your expression in the PAC delay column?
You can add a 1 to the set analysis to have it ignore selections.

For example: Rank(Sum({1} Sales))

Or if you need it to have some selections: Rank(Sum({1<Product = {'Shoe'}>} Sales))
Partner
Partner

Re: How to fix the table static?

Hi. 

the 1 should go here..

if(Sum(Go_Live)>3500, null(),
Sum({1<Snapshot_Date = {">=$(=Date(Addmonths(Max({1} Snapshot_Date),0), 'YYYY-MM-DD'))"}>}Go_Live)
/
count({1<Snapshot_Date = {">=$(=Date(Addmonths(Max({1} Snapshot_Date),-1), 'YYYY-MM-DD'))"}>}distinct Milestone_Project_Number))

 

try that.

3 Replies
jensmunnichs
Contributor III

Re: How to fix the table static?

What is your expression in the PAC delay column?
You can add a 1 to the set analysis to have it ignore selections.

For example: Rank(Sum({1} Sales))

Or if you need it to have some selections: Rank(Sum({1<Product = {'Shoe'}>} Sales))
bhaveshp90
Contributor III

Re: How to fix the table static?

I have the below expression;

 if(Sum(Go_Live)>3500, null(),
Sum({<Snapshot_Date = {">=$(=Date(Addmonths(Max({1} Snapshot_Date),0), 'YYYY-MM-DD'))"}>}Go_Live)
/
count({<Snapshot_Date = {">=$(=Date(Addmonths(Max({1} Snapshot_Date),-1), 'YYYY-MM-DD'))"}>}distinct Milestone_Project_Number))

I tried to include {1} before Sum and count expression, but it is not working out. Can you tell me where should I use {1} in my expression.

 

Partner
Partner

Re: How to fix the table static?

Hi. 

the 1 should go here..

if(Sum(Go_Live)>3500, null(),
Sum({1<Snapshot_Date = {">=$(=Date(Addmonths(Max({1} Snapshot_Date),0), 'YYYY-MM-DD'))"}>}Go_Live)
/
count({1<Snapshot_Date = {">=$(=Date(Addmonths(Max({1} Snapshot_Date),-1), 'YYYY-MM-DD'))"}>}distinct Milestone_Project_Number))

 

try that.