Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Simon4
Creator
Creator

Cleaner and better set analysis

Dear all,

I have a margin formula with set analysis. this is the syntax:

Simon4_0-1671698729303.png

How can I make this cleaner? 

It is neccesairy because the set analysis identifier (1) does not work. when I select other weeks than "currentweek" it shifts to zero.

 

Thank you in advance,

 

simon

Labels (1)
2 Replies
Michiel_QV_Fan
Specialist
Specialist

is the peildatum  a value in the currentweek? if your data is not deriving these to date fields, peildatum and currentweek from a master calendar then I would expect that these 2 cancel each other and result in the 0 value.

What is your question in making this cleaner? Which part do you want to clean?

Simon4
Creator
Creator
Author

no peildatum and currentweek are two different values. 

my end goal is to make it ignore filters. now when i set the year filter on 2021 it shifts to zero, but with the set analysis identifier 1 it should ignore filters