Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

marishnagendran
Contributor

Measure as dimension and calculate a another measure

Dear All,

DateProduct Product_TypeQtyGross ProfitNet ProfitMarigin
       
11-JunATest101082
11-JunBTest2020155
11-JunCTest100302010
11-JunDTest8015105
11-JunETest4020515

 

My OutPut:

DimensionNet Profit
0-5028
50-10030

 

0-50 & 50-100 is Qty

 

Is it possible?

2 Replies
Highlighted
Partner
Partner

Re: Measure as dimension and calculate a another measure

simplest is to create your dimension while loading the data.
e.g.
if( quantity<=50, '0-50','50-100') as NewDimension

and use that in your table.

Hope i understood the issue clearly
marishnagendran
Contributor

Re: Measure as dimension and calculate a another measure

In Front-end i want to do this