topic Set analysis expression issue in QlikView

Set analysis expression issue

miranrai — Tue, 08 Dec 2015 07:32:39 GMT

Hi, I have tow tables one is master table which has dimensions such as time_date (date) field ,customer , sales status , watchID and sales data and other table in which i have separately calculated previous month and previous quarter value of a sales status columns are like, time_date, previous_month_sales_status, previous_qtr_sales_status etc and joined these two tables on time_date+Customer key. Now in my straight table chart , I am using set analysis to calculate current Max month and previous month using variables and using those variables in expression but i am getting 2 rows in my chart i am not sure whats going wrong.

Fore current month its showing previous month sales value as 0 and other way too. Any help?

Thank you.

Customer	Current Sales Status	Prev Month Sales St	Prev QTR Sales St	Prev To Prev Qtr Sales Status	Current Month Sales	Previous Month Sales
ABC	XX	YY	FD	GG	0	400
ABC	XX	YY	FD	HU	100	0

Re: Set analysis expression issue

SunilChauhan — Wed, 09 Dec 2015 05:09:51 GMT

remove prev to prev quarter sales status. it is due to this.

Re: Set analysis expression issue

tyagishaila — Wed, 09 Dec 2015 06:00:10 GMT

Because you have two different status (Prev To Prev Qtr Sales Status) for both

Current Month Sales and Previous Month Sales

Re: Set analysis expression issue

miranrai — Wed, 09 Dec 2015 08:27:13 GMT

Yes, its because I am having previous month/QTR/Yr status in my straight table. But I can't remove it as client want to see these status in same chart. So can anything be done on expression level to get the result without removing previous thing?? thanks for your reply.

Re: Set analysis expression issue

SunilChauhan — Thu, 10 Dec 2015 02:46:19 GMT

i thing nothing wrong with it. it will show 2 rows Prev To Prev Qtr Sales Status

one for CG and one for HU.

this is how Qlikview works

Re: Set analysis expression issue

tyagishaila — Thu, 10 Dec 2015 05:06:21 GMT

If you want to have column Prev to Prev Qtr Sales.

thn your table is okay.

Or let us know, what output you exactly want ?

Re: Set analysis expression issue

miranrai — Fri, 11 Dec 2015 04:09:21 GMT

Ok.. Let me explain you my issue in detail. In this table 2nd record for which Prev To Prev Qtr Sales Status ='HU' is the correct record. Prev To Prev Qtr Sales Status ='GG' is the wrong one for previous to previous Qtr this GG value is coming from Previous Month (I don't know why so .. I guess as i have used Previous Month in set analysis that's why this record is popping up.). whats i want is to remove this GG record which i achieved by adding one more condition into my current month & previous month expression condition timedate from sales status = current month. But for previous month its still showing 0 value. I am attaching a sample qvw for reference.

stomer	Current Sales Status	Prev Month Sales St	Prev QTR Sales St	Prev To Prev Qtr Sales Status	Current Month Sales	Previous Month Sales
ABC	XX	YY	FD	GG	0	400
ABC	XX	YY	FD	HU	100	0

my desire result set is

Customer	Current Sales Status	Prev Month Sales Status	Prev QTR Sales St	Prev To Prev Qtr Sales St	Curr Month Sales	Previous Mon Sales
ABC	XX	YY	FD	HU	100	400