topic Re: selected values in QlikView

selected values

sakamsureshbabu — Tue, 04 Nov 2014 11:18:33 GMT

in my exp i need selected sum like

sum(total)

but total value based on "bill type = B "

how can i get

Re: selected values

MK_QSL — Tue, 04 Nov 2014 11:21:33 GMT

SUM({<[bill type] = {'B'}>}total)

Re: selected values

Agis-Kalogiannis — Tue, 04 Nov 2014 11:52:08 GMT

Set Analysis is the syntax you are looking for Suresh

sum({$<[bill type] = {'B'}>}total)

Re: selected values

its_anandrjs — Tue, 04 Nov 2014 11:57:18 GMT

You can write with if expression also i assume total is field here

SUM(if( [bill type] = 'B' , total ) )

SUM( { < [bill type] = {'B'} >} total )

Regards

Anand

Re: selected values

sakamsureshbabu — Tue, 04 Nov 2014 12:01:23 GMT

it is not work

(SUM({<BILLCATEGORYNAME = {'GOLD BILL'}>}BILLGROSSAMOUNT)/AmtFlag)

(SUM({<BILLCATEGORYNAME = {'[GOLD BILL]'}>}BILLDISCOUNT)/AmtFlag)

this my exp is correct

Re: selected values

sakamsureshbabu — Tue, 04 Nov 2014 12:01:39 GMT

it is not work

(SUM({<BILLCATEGORYNAME = {'GOLD BILL'}>}BILLGROSSAMOUNT)/AmtFlag)

(SUM({<BILLCATEGORYNAME = {'[GOLD BILL]'}>}BILLDISCOUNT)/AmtFlag)

this my exp is correct

Re: selected values

Agis-Kalogiannis — Tue, 04 Nov 2014 12:04:16 GMT

Hi Suresh

I see that you have some extra square brackets there on the second expression

Try the following:

(SUM({<BILLCATEGORYNAME = {'GOLD BILL'}>}BILLGROSSAMOUNT)/AmtFlag)

(SUM({<BILLCATEGORYNAME = {'GOLD BILL'}>}BILLDISCOUNT)/AmtFlag)

You need to know though that Fieldnames and values are both case sensitive.

Agis

Re: selected values

sakamsureshbabu — Tue, 04 Nov 2014 12:14:40 GMT

thanks agis it is working

Re: selected values

its_anandrjs — Tue, 04 Nov 2014 12:24:49 GMT

Hi,

In first expression you use 'GOLD BILL' but in second it is with [GOLD BILL] you have to take exactly same field string available in the BILLCATEGORYNAME then it will works

try to check this if it is GOLD BILL

(SUM({<BILLCATEGORYNAME = {'GOLD BILL'}>}BILLGROSSAMOUNT)/AmtFlag)

(SUM({<BILLCATEGORYNAME = {'GOLD BILL'}>}BILLDISCOUNT)/AmtFlag)

Regards

Anand

Re: selected values

sakamsureshbabu — Tue, 04 Nov 2014 12:25:48 GMT

my dimension is ornament but i want show in pivot table with selected "brand"

condition is "BRAND=Y"

how can i show

Re: selected values

sakamsureshbabu — Tue, 04 Nov 2014 12:26:14 GMT

my dimension is ornament but i want show in pivot table with selected "brand"

condition is "BRAND=Y"

how can i show

Re: selected values

MK_QSL — Tue, 04 Nov 2014 12:28:42 GMT

Provide some sample data...

Re: selected values

its_anandrjs — Tue, 04 Nov 2014 12:31:28 GMT

Then write

Sum( {< BRAND = {'Y'} >} AmountMetric)

For new question post new thread please

Regards

Anand

Re: selected values

sakamsureshbabu — Tue, 04 Nov 2014 12:40:13 GMT

I need dimension row

how can i get

Re: selected values

Agis-Kalogiannis — Tue, 04 Nov 2014 12:43:15 GMT

Create your pivot table and select your dimensions (ornament and brand for example)

Then you can drag the dimension column (brand) in you pivot table and move it as a row on the top of the table (horizontal blue arrow).

Is this what you're trying to do?

Re: selected values

its_anandrjs — Tue, 04 Nov 2014 12:45:26 GMT

If it is dimension

If( Match( BRAND,'Y'),BRAND) //And in properties use Suppress When Value is Null

or in load script you can filter that records

Load

If( Match( BRAND,'Y'),BRAND) as [Y Brands]

From Location;

Provide and sample file

Regards

Anand

Re: selected values

Michael_Tarallo — Tue, 04 Nov 2014 12:45:26 GMT

Hello Suresh - I noticed you have been posting QlikView questions NON-related to the QlikView Deployment Framework in the QDF section - can you please post your QlikView questions to:

New to QlikView

Thank you

Regards,

Mike Tarallo

Qlik

Re: selected values

Agis-Kalogiannis — Tue, 04 Nov 2014 12:48:22 GMT

Could you please mark my answer correct or Helpful if it's working and ask any other questions by creating a new post?

thanks Suresh

Agis

Re: selected values

MK_QSL — Tue, 04 Nov 2014 12:50:37 GMT

Request you to close the thread by selecting correct/helpful answer rather than asking another question on the same thread.. By closing the thread will help other users who are facing similar problems..

Thanks...

Re: selected values

its_anandrjs — Tue, 04 Nov 2014 12:58:12 GMT

Hi,

Close the thread by selecting appropriate answer as correct or helpful for references for new question open new thread.

Regards

Anand