Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

afuchten
Valued Contributor

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

Tags (2)
1 Reply
afuchten
Valued Contributor

override dimension partly?? or is there another way?

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

Community Browser