Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

aryanreddy
New Contributor II

How to write 2 or 3 calculations in one measure

Hi everyone

How can i write 2 or 3 calculation as one measure

For example I have below calculations

(Count(distinct total [EMployeeID-MF]),

Sum(total [Hours-MF]),

Sum(total [Total-MF]),

Sum(total [Total-MF]))

I want to display each calculation in each row of a table how can i do.

row.JPG

2 Replies
Ivan_Bozov
Valued Contributor

Re: How to write 2 or 3 calculations in one measure

Try like this:

Measure1  & '  ' &  Measure2 & '  ' & Measure3

Re: How to write 2 or 3 calculations in one measure

Hi Aryan, if you want all measures for each code in rows you can use a pivot table, create a measure for each expression and drag measures to be shown as rows

Community Browser