topic Re: Set in set in QlikView

Set in set

Tue, 29 Apr 2014 04:41:37 GMT

Hi all! not work set with set.

count({<%date={">=$(=date(vMaxDateSale-15))<=$(=date(vMaxDateSale))"},

nomenclature={"=sum({<%date={">=$(=date(vMaxDateSale-15))<=$(=date(vMaxDateSale))"}residue)>=vAvgOst"},

nomenclature={"=sum({<%date={">=$(=date(vMaxDateSale-15))<=$(=date(vMaxDateSale))"}cost)>0"}>}

nomenclature)

where vMaxDateSale=41638

write error

Tue, 29 Apr 2014 06:07:22 GMT

=count({1<%date={">=$(=date(max(%date)-15))<=$(=date(max(%date)))"},

nomenclature={"=sum({1<%date={">=$(=date(max(%date)-15))<=$(=date(max(%date)))"}>}cost)>0"}

>} nomenclature)

new....but not work

MK_QSL — Tue, 29 Apr 2014 06:14:52 GMT

Try First Portion and let me know whether it's working or not...

=count({<%date={">=$(=date(max(%date)-15))<=$(=date(max(%date)))"}>} nomenclature)

Tue, 29 Apr 2014 07:43:29 GMT

work

MK_QSL — Tue, 29 Apr 2014 08:29:20 GMT

Now Check below by creating a Straight Table

Dimension

nomenclature

Expression

=IF(sum({<%date={">=$(=date(vMaxDateSale-15))<=$(=date(vMaxDateSale))"}cost)>0,1,0)

Tue, 29 Apr 2014 09:44:07 GMT

work.

MK_QSL — Tue, 29 Apr 2014 09:55:26 GMT

Is it possible to upload sample apps or sample data file?

Tue, 29 Apr 2014 10:33:18 GMT

No. It on server of another company... only screens and code

MK_QSL — Tue, 29 Apr 2014 10:41:26 GMT

Can't you create dummy data in excel file (Only 10-15 lines)