Pivot table with sliced measurements

[Anonymous]

Hello,

i  want to  create  a pivot table in qv like this one:

to  calculate the number of unique card fid :'Nb Unique Carte Fid' :

A:

=(count(distinct((if([Encarté]<>'0'and [Encarté]<> null()  ,[Fid])))))

to  calculate the amount :

B:

= sum(if([Encarté]<>'0' and ([Encarté])<> null(),([Prix de vente TTC]),0))

i need the expression  to  calculate  A WHEN B  between  0.001 and  23.000

thank you

[sunny_talwar]

Would you be able to share some raw data behind this sort of output you are looking to get?

QlikCommunity Tip: How to get answers to your post?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

[Anonymous]

i  want  to  calculate:

count(  x)  when   sum(y) between  0.1 and 20 

[Anil_Babu_Samineni]

May be this?

count({<x = {"=sum(y) >0.1 and sum(y) <20"}>} x )

Or

Count(If(Aggr(Sum(y), x)>0.1 and Aggr(Sum(y), x)<20, x))