topic Creating a table from an Existing Table in QlikView

Creating a table from an Existing Table

Anonymous — Fri, 16 Oct 2015 10:19:43 GMT

I have a View from SQL Server database. It has fields like

Brand

Product

Sales

With the help of above table I need to create a field which will display the Sales range for each Brand (Not Product)

My Table should look like

Brand

Sales Range

Product

Sales

For Sales Range, my condition would be if the Sum(Sales)>100 for a particular Brand then Sales Range should have the value '>100'

This is how my Table should look

Brand	Sales Range	Product	Sales
TITAN	>100	FASTRACK	50
TITAN	>100	SONATA	80
TAG	NULL	WAT	30

The solution would be an easy one. But I'm not sure how to do this in Qlikview. Any kind of help is much appreciated.

jsingh71 — Fri, 16 Oct 2015 10:25:06 GMT

Share some sample data....

somenathroy — Fri, 16 Oct 2015 10:41:53 GMT

You may try like this at script level:

Use preceding load to calculate Range

Load Brand, if(Sales > 100,'>100',Null()) as Range;

Load Brand, Sum(Sales) as Sale

From <SQL_View_Table>

Group By Brand;

Then join with original table like:

Left Join(<SQL_View_Table>)

If you wish to do the same at UI, then try with calculated dimention by using Aggr function.

Regards,

Som