topic Re: HI I AM NEW HERE in QlikView

HI I AM NEW HERE

Fri, 03 Apr 2015 08:03:49 GMT

I AM USING COMBO CHAT HAVE A SALE AND YEAR AND CATEGORIES I WANT TO SHOW MEMBER OF CATEGORIES THAT IS MEN's Clothes and Baby Clothes, Men's Clothes is content line another one baby clothes should change what's the solution

i am giving expression as : 1.sum({<Category={"Men's Clothes"}>}sales)

2.sum({<Category={"Baby Clothes"}>}sales)

this expression is right or wrog

thanks......

Re: HI I AM NEW HERE

amit_saini — Fri, 03 Apr 2015 08:15:01 GMT

right

You can also do this way based on current selection:

Ex: sum({$ <Category={"Men's Clothes"} sales)

Thanks,

Re: HI I AM NEW HERE

amit_saini — Fri, 03 Apr 2015 08:16:18 GMT

Also this will help u:

Sum({Book1} [Sales]) : sales of the selection of Book1

Sum({Group1} [Sales]) : sales of the Alternate State Group1 (the syntax is identical)

Sum({1} [Sales]) : sum of everything (All dimensions are completly reset to All)

Sum({$} [Sales]) : sum of the current selection (= sum([Sales])

Thanks,
AS