topic Re: explain plz???? in QlikView

explain plz????

stonecold111 — Sat, 22 Apr 2017 06:54:05 GMT

someone explain this???

Num( Sum( {$< CYTD={1}, Year=, Quarter=, Month=, [Month In Quarter]=>}

(Pick([ Key], [ Sales], [Qty Sold], [Gro Sales], [Pro Sales], [ List Price])) / [Divisor]), Pick(WildMatch([Divisor], 1, 1000, 1000000), '#,##0', '#,##0', '#,##0.0'))

Re: explain plz????

rahulpawarb — Sat, 22 Apr 2017 07:52:44 GMT

Hello Suresh,

Please refer below given steps:

1. (Pick([ Key], [ Sales], [Qty Sold], [Gro Sales], [Pro Sales], [ List Price])) / [Divisor]

This expression will first select a measure from list [Sales], [Qty Sold], [Gro Sales], [Pro Sales] & [List Price] based on Key field value. If value of Key field is 1 then it will return [Sales], if 2 then [Qty Sold], if 3 then [Gro Sales] and so on. Post that it will divide it by [Divisor] field.

2. Sum({$<CYTD={1}, Year=, Quarter=, Month=, [Month In Quarter]=>}

(Pick([ Key], [ Sales], [Qty Sold], [Gro Sales], [Pro Sales], [ List Price])) / [Divisor])

This statement will transform the result of point no. 1 to consider records for CYTD = 1 Only.

3. Pick(WildMatch([Divisor], 1, 1000, 1000000), '#,##0', '#,##0', '#,##0.0')

This expression will return the number format based on divisor value.

4. Num(Sum({$<CYTD={1}, Year=, Quarter=, Month=,[Month In Quarter]=>} (Pick([ Key], [ Sales], [Qty Sold], [Gro Sales], [Pro Sales], [ List Price])) / [Divisor]), Pick(WildMatch([Divisor], 1, 1000, 1000000), '#,##0', '#,##0', '#,##0.0'))

Finally we will use Num function to apply the formatting produced by point # 3 to the result of Point #2.

Hope this will be of help.

Regards!
Rahul

Re: explain plz????

vinieme12 — Sat, 22 Apr 2017 07:53:15 GMT

Num( 《《 for fomenting the returned value

Sum( {$< CYTD={1}, Year=, Quarter=, Month=, [Month In Quarter]=>} 《《 Set analysis, probably current ytd = yes and ignore all other date filters

(Pick([ Key], [ Sales], [Qty Sold], [Gro Sales], [Pro Sales], [ List Price])) 《《 enabled user to select the metrics they want to see so if sales is selected in list box then sales column will be aggregated similar for qty ,gross sales , pro sales etc

/ [Divisor]),

Pick(WildMatch([Divisor], 1, 1000, 1000000), '#,##0', '#,##0', '#,##0.0')) 《《 depending upon the divisor that is selected in listbox the number will be formatted thousands or millions .