Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

cbaqirdhds
Valued Contributor

Show if expression greater than x

I want only the rows to show where Expression 3 >=50%. For some reason, I am having trouble with this. I see all the rows.

Dimension: RULE

Expression 1: count( {$<USER_POSITION_FLAG={'y'}>} DLG_EVENT_ID)

Expression 2:  Count (DISTINCT FIRING_RECORD)

Expression 3: count(DISTINCT{$<USER_POSITION_FLAG={'y'}>} DLG_EVENT_ID)/Count (DISTINCT FIRING_RECORD)

Expression 3 Conditional: if( (count( {$<USER_POSITION_FLAG={'y'}>} DLG_EVENT_ID)/Count (DISTINCT FIRING_RECORD))>=.5, count( {$<USER_POSITION_FLAG={'y'}>} DLG_EVENT_ID)/Count (DISTINCT FIRING_RECORD))

Labels (1)
1 Solution

Accepted Solutions
Highlighted

Re: Show if expression greater than x

Try this

Expression 1:
Count({$<USER_POSITION_FLAG = {'y'}, RULE = {"=Count(DISTINCT{$<USER_POSITION_FLAG = {'y'}>} DLG_EVENT_ID)/Count(DISTINCT FIRING_RECORD) >= 0.50"}>} DLG_EVENT_ID)

Expression 2:
Count(DISTINCT {<RULE = {"=Count(DISTINCT{$<USER_POSITION_FLAG = {'y'}>} DLG_EVENT_ID)/Count(DISTINCT FIRING_RECORD) >= 0.50"}>} FIRING_RECORD)

Expression 3:
Count(DISTINCT {$<USER_POSITION_FLAG = {'y'}, RULE = {"=Count(DISTINCT{$<USER_POSITION_FLAG = {'y'}>} DLG_EVENT_ID)/Count(DISTINCT FIRING_RECORD) >= 0.50"}>} DLG_EVENT_ID)
/
Count(DISTINCT {<RULE = {"=Count(DISTINCT{$<USER_POSITION_FLAG = {'y'}>} DLG_EVENT_ID)/Count(DISTINCT FIRING_RECORD) >= 0.50"}>} FIRING_RECORD)
2 Replies
Highlighted

Re: Show if expression greater than x

Try this

Expression 1:
Count({$<USER_POSITION_FLAG = {'y'}, RULE = {"=Count(DISTINCT{$<USER_POSITION_FLAG = {'y'}>} DLG_EVENT_ID)/Count(DISTINCT FIRING_RECORD) >= 0.50"}>} DLG_EVENT_ID)

Expression 2:
Count(DISTINCT {<RULE = {"=Count(DISTINCT{$<USER_POSITION_FLAG = {'y'}>} DLG_EVENT_ID)/Count(DISTINCT FIRING_RECORD) >= 0.50"}>} FIRING_RECORD)

Expression 3:
Count(DISTINCT {$<USER_POSITION_FLAG = {'y'}, RULE = {"=Count(DISTINCT{$<USER_POSITION_FLAG = {'y'}>} DLG_EVENT_ID)/Count(DISTINCT FIRING_RECORD) >= 0.50"}>} DLG_EVENT_ID)
/
Count(DISTINCT {<RULE = {"=Count(DISTINCT{$<USER_POSITION_FLAG = {'y'}>} DLG_EVENT_ID)/Count(DISTINCT FIRING_RECORD) >= 0.50"}>} FIRING_RECORD)
cbaqirdhds
Valued Contributor

Re: Show if expression greater than x

Thanks, my friend!