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: 
Anonymous
Not applicable

override dimension partly?? or is there another way?

Hi all,

In the dimension I have a list of serial numbers with status <> 'Booked'. (Since I only want to see the serial numbers which have open records).

In the expression I need to count all previous records and the current record for this serialnumber list ... so I want to overrule the dimension partly to retrieve also the records for the count with status = 'Booked'.

I tried this with set analysis by setting {<Status = >} but this did not the trick.

Now I wonder if there is any way to overrule this Status which is used in the dimension??

I did also try it otherwise so all serialnumbers are in the dimension ... to retrieve the last ordernumber for the serialnumber, this works but now I also have all serialnumbers which I don't need to see (the ordernumber is empty for those) ... Could it be a solution to use the selection for the expressions to be null to filter out the serialnumbers in the dimension??

Hope someone can help me finding a clue ...

Anita

1 Reply
Anonymous
Not applicable
Author

What I do now is to check if the expression of the last column is null, if so I make the expressions in all other columns to be null too ...

Don't think this is a good solution ... but can't find anything else ...

Someone got ideas??