topic Re: Set Analysis in QlikView

Set Analysis

soha1902 — Thu, 21 Aug 2014 10:36:13 GMT

Hi All,

Its a straightforward question:

I have Status Field in my dimension and one expression.

Status field having values Open,Closed, OnHold,Freeze and Waiting. I want to show all the values except Closed.

For this I wrote below expression in Calculated dimension

Only({<Status -= {'Closed'}>} Status)

It not showing any error message but it not showing the correct value also. Please help

vardhancse — Thu, 21 Aug 2014 10:39:49 GMT

Try Only({<Status <> {'Closed'}>} Status)

Only({<Status = {"*"} - {'Closed'}>} Status)

Gysbert_Wassenaar — Thu, 21 Aug 2014 10:43:20 GMT

Put the condition in the expression instead: Count({<Status-={Closed}>}IssueID).

vardhancse — Thu, 21 Aug 2014 10:47:08 GMT

if we want to give in calculated dimension, then

Aggr(Only({<Status -= {'Closed'}>} Status),Status)