Discussion board where members can get started with QlikView.
I am struggling with creating the necessary calculated dimension / expression to create a bar chart with custom ranges. Please see my data set below
I am trying to create the bar chart showing the # of trades that fall into the following buckets while using an "if Statement":
Each Trade ID is unique. Please help or my keyboard gets thrown across the room!
Try like this,
In script ,
Load *, if(Amount in EUR >= 0 and Amount in EUR <= 25000,'0-25000', if(Amount in EUR <= 50000,'25000-50000',
if(Amount in EUR <=100000,'50000-100000',if(Amount in EUR <= 200000, '100000-200000','200000+')))) as Bucket from tablename;
Then use Bucket as dimension, and count(Trade ID) as Exp
Hope that helps
I agree that should work, but I am also trying to understand how to do this through using "if statements". I believe I will need to create a custom dimension, but I am having trouble with getting getting started in the right direction...
Please see the attached file..
Sheet name: Bucket
Hope it helps