topic Re: How to write set analysis ? in QlikView

How to write set analysis ?

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

Hi all,

How to write set analysis ?

My expression :

sum({$<TranType = {$(vAmountType)}>} Amount)

I need the sales should be calculated on current_date but the results is only displaying for trans Date 20140206 .

Thanks,

Re: How to write set analysis ?

avinashelite — Tue, 07 Feb 2017 11:57:01 GMT

Does your data has the current date to compare ? if they add one more condition in the set analysis this

sum({$<TranType = {$(vAmountType)},current_date={$(vCurrentdate)}>} Amount)

set the variable

vCurrentdate= today()

Format the date according to your need

Re: How to write set analysis ?

surendraj — Tue, 07 Feb 2017 12:02:12 GMT

May be this..

sum({1<current_date>}Amount)

Re: How to write set analysis ?

sunny_talwar — Tue, 07 Feb 2017 12:14:56 GMT

It seems you have made selection in Trans_Date field... is that something you will be doing in your dashboard or is that by mistake? Can you share your app to look at it?

Re: How to write set analysis ?

suvechha_b — Tue, 07 Feb 2017 12:21:11 GMT

If I select one [Trans Date] like '20140206' , I will have three current_date like 20140206 , 20150206 and 20170206.

how to do the sum of sales depending on current_date.

My expression :

sum({$<TranType = {$(vAmountType)}>} Amount)

My [Trans Date] and current_date are dynamic.

Re: How to write set analysis ?

sunny_talwar — Tue, 07 Feb 2017 12:24:06 GMT

So you want to see where Trans Date = Current Date?

Re: How to write set analysis ?

suvechha_b — Tue, 07 Feb 2017 12:25:12 GMT

No , all the three urrent_date like 20140206 , 20150206 and 20170206 with three different sales value.

Re: How to write set analysis ?

sunny_talwar — Tue, 07 Feb 2017 12:29:16 GMT

But you mentioned:

"how to do the sum of sales depending on current_date"

What does the above mean?

Re: How to write set analysis ?

suvechha_b — Tue, 07 Feb 2017 12:34:44 GMT

For example ,

If I select one [Trans Date] like '20140206' ,

I will get three current_date like 20140206 , 20150206 and 20170206

how to write the expression of getting sales.

My expression :

sum({$<TranType = {$(vAmountType)}>} Amount)

According to my expression , the results is only showing sales for [Trans Date] and current_date '20140206'

My req :

The sales value should change on the last two current date in the screen shot.

Re: How to write set analysis ?

sunny_talwar — Tue, 07 Feb 2017 12:38:52 GMT

Okay, I sort of understand what you want, but have no idea about your data model and it would be difficult for me to suggest anything without looking at how things are. Would you be able to share a sample?

Preparing examples for Upload - Reduction and Data Scrambling

Re: How to write set analysis ?

suvechha_b — Tue, 07 Feb 2017 12:52:09 GMT

Please find the sample attached.

Re: How to write set analysis ?

sunny_talwar — Tue, 07 Feb 2017 13:00:49 GMT

It seems that your data model is what might be causing the issue. Look at this table box

It seems that Amount values repeat for each of the current_date. Now how would you decide which Amount value should show up for which current_date? Attaching the qvw back with the table box for you to see.