Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
krishna4bo
Contributor

QS Extension table

Hi All,

How to write measures in  QS Extension table.

Dimension: [Affected Device]

Measure:

if(GetSelectedCount(Affected_Month)>0,

Round(Sum([Overall Availability%])/Count([Overall Availability%]))&''& '%',

Round(Sum({<Affected_Date={'$(=Max(Affected_Date))'}>}[Overall Availability%])/

Count({<Affected_Date={'$(=Max(Affected_Date))'}>}[Overall Availability%]))&''& '%')

i need below out put based on data.

Dimension: Valuelist('Status')

Capture.PNG

Regards,

Krishna

Tags (1)
2 Replies
OmarBenSalem
Esteemed Contributor

Re: QS Extension table

Hi Krishna,

I did not understand one thing;

ur dimension is Status based on ur valueList or affected device?

krishna4bo
Contributor

Re: QS Extension table

Hi Omar,

For status i created value list.

Data: 

[Affected Device]Availability
LAN Media100%
WAN Media98%
Hub98%
Firewall98%
Router98%
Server98%
IP Phone98%
Cloud98%
Windows Server 201298%
LAN%

out put:

Capture.PNG

Regards,

Krishna.