topic Re: How to fix the table static? in QlikView

How to fix the table static?

bhaveshp90 — Sat, 16 Nov 2024 21:47:14 GMT

Hello,

I have a simple straight table as shown below;

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

Re: How to fix the table static?

jensmunnichs — Mon, 03 Dec 2018 15:08:35 GMT

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))

Re: How to fix the table static?

bhaveshp90 — Mon, 03 Dec 2018 16:14:19 GMT

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.

Re: How to fix the table static?

hopkinsc — Mon, 03 Dec 2018 16:30:16 GMT

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.