topic Re: Selection criteria in QlikView

Selection criteria

Karim_Khan — Thu, 20 Aug 2015 15:18:35 GMT

Hi Team,

I wanted to do calculation for finding bookings.

Which will be like

SUM([Sales Level2/[Sales Level1])

Its a dynamic value.Pls suggest

Whenever I click on Sales Level 1 and Sales Level 2 then it should give the calculation.

Regards,

jagan‌gwassenaar‌MRKachhiaIMP‌ashfaq_haseeb‌Kush141087‌

Re: Selection criteria

Thu, 20 Aug 2015 15:25:42 GMT

You can show the Chart or in Text object by enabling conditional show option on the object Properties Layout.

GetselectedCount([Sales Level2]) and GetselectedCount([Sales Level1])

Re: Selection criteria

Thu, 20 Aug 2015 15:35:38 GMT

Please find the attached qvw.

Re: Selection criteria

Karim_Khan — Thu, 20 Aug 2015 15:41:41 GMT

Hi,

Suppose If I select Only Sales Level 1 Americas m then it should calculate the value which are mapped in Sales Level 2

Like CANDA,US COMMERCIAL,USA etc. and Vice versa.

If I select Only Sales Level 2 Canada then it should calculate the value which are mapped in Sales Level 1

Like Amercia Only.

Re: Selection criteria

Thu, 20 Aug 2015 15:54:55 GMT

Simply change the condition to below:

GetselectedCount([Sales Level2]) OR GetselectedCount([Sales Level1])

Re: Selection criteria

Thu, 20 Aug 2015 15:56:18 GMT

Find the modified qvw.

Re: Selection criteria

Kushal_Chawda — Thu, 20 Aug 2015 16:17:08 GMT

Please see the attached.

I think you need the Alternate state, But right now I have done as per your requirement.

Re: Selection criteria

Karim_Khan — Fri, 21 Aug 2015 09:26:22 GMT

Hi Kush,

In your QVW while am selecting only Americas then it should only give American region which are

AMERICA,CANADA,LATAM,US COMMER,US ENTERP,US OTHERS AND US PS MARKET.

But in given qvd its picking the entire Sales Level 2

Regards,

Karim Khan

Re: Selection criteria

Kushal_Chawda — Fri, 21 Aug 2015 09:33:44 GMT

Please see the attached

Re: Selection criteria

Karim_Khan — Fri, 21 Aug 2015 10:50:24 GMT

Once Again tnx Bro.

Re: Selection criteria

Karim_Khan — Fri, 21 Aug 2015 10:56:07 GMT

Hi Kush,

pls jst explain me

=Concat(DISTINCT chr(39)& [Sales Level 1]& chr(39),',')

how above expression works

Re: Selection criteria

Kushal_Chawda — Fri, 21 Aug 2015 11:04:16 GMT

I have used the concat function to associate the possible Field values or selected Field values, So that I can pass this values in Set Expression

Like when you do set analysis ,you need to write Field ={'1','2'....}

But we need to associate all values in single quotes which is done using chr(39)

Re: Selection criteria

Karim_Khan — Fri, 21 Aug 2015 11:07:15 GMT

so chr(39) is a in built function or what?

Re: Selection criteria

Kushal_Chawda — Fri, 21 Aug 2015 11:09:20 GMT

Yes,it is inbuilt

Re: Selection criteria

Karim_Khan — Fri, 21 Aug 2015 11:12:04 GMT

ok Got it Tnx yaar

Re: Selection criteria

Kushal_Chawda — Fri, 21 Aug 2015 11:14:02 GMT

welcome bro