topic Re: set analysis for * and specific text in QlikView

set analysis for * and specific text

Wed, 29 Jan 2014 09:16:16 GMT

Hi All,

I have a pivot table with particulars having different text like Collection/ Sale etc.

for this I have to write set analysis as below:

sum({< DocType = {'DZ'} >} Amt) - for collections

sum({< DocType = {'*'} >} Amt) - for sales

so I have created 1 excel maintining text and its corresponding doc type.

Particulars DT -header

Collections DZ

Sale *

from DB I get column DocType with text as DZ/ KZ/ etc

and I have written common expression as

sum({< DocType = p(DT) } >} Amt)

this above expression works fine for collection where specific doctype is required

and where all doctypes are required it is not working.

Please can you help me in writing expression which will work for both DZ and *.Administrator

Re: set analysis for * and specific text

MK_QSL — Wed, 29 Jan 2014 09:22:43 GMT

You can use above mentioned two expressions and group them....

Or Create a List Box Showing DZ and *...

and use Sum(Amt) as expression...

Re: set analysis for * and specific text

jagan — Wed, 29 Jan 2014 09:24:16 GMT

Hi,

Can you attach some sample document?

Regards,

Jagan.,

Re: Re: set analysis for * and specific text

Wed, 29 Jan 2014 10:13:00 GMT

HI Jagan,

Please find an attachment. I have attached one sample.

Re: set analysis for * and specific text

MK_QSL — Wed, 29 Jan 2014 10:19:34 GMT

Go to presentation tab and tick Suppress Zero Values...

Re: set analysis for * and specific text

jagan — Wed, 29 Jan 2014 10:25:35 GMT

Hi,

Can you comeup with an example about what exactly you need. Try this

num(sum({< Year =, Month =, Day =,DocType = {*},

PostingDate = {'>=$(=Date(min(CalenderDate))) <=$(=Date(max(CalenderDate)))'} >} Amt), $(varDecimals))

Regards,

Jagan.

Re: Re: set analysis for * and specific text

Wed, 29 Jan 2014 10:40:02 GMT

If in the excel column DocType 'DZ' is available, then it should link with DocType 'DZ' from DB

if excel column '*' is available, then it should link Doctype field in DB with all available data.

In short, Doctype from excel and Doctype from DB should link.

Please can u make 1 change in the excel. change the header from Doctype to DT.

as I have written expression considering DT.

I have tried to explain what exactly I need, if still not clear do as again.