topic Pivot table with sliced measurements in QlikView

Pivot table with sliced measurements

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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' :

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

to calculate the amount :

= 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 — Tue, 24 Jan 2017 19:28:07 GMT

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

Anonymous — Thu, 02 Feb 2017 14:22:26 GMT

i want to calculate:

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

Anil_Babu_Samineni — Thu, 02 Feb 2017 14:30:02 GMT

May be this?

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

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