Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Straight table combining expressions

I have a straight table with one Dimension, Name and two expressions, # of Purchases and YTD Amount.  The result set relies on the expressions working together, meaning, I need to only see the total # of Purchases that are greater than 10 and where the YTD Amount is greater than 10,000.  How can I write the two expressions?

18 Replies
Highlighted
Master II
Master II

Give a try on the below:

Sum({<[# Of Purchases]={"$(=Count([# Of Purchases])>10"},[YTD Amount] = {'>10,000'}>} [# Of Purchases])

If this is not helping, can you please post a small sample.

Highlighted
Creator II
Creator II

That is only one expression.  Is the YTD Amount expression just a straight forward Sum?

Highlighted
Creator
Creator

Post your sample data and your expression

Highlighted
Master II
Master II

The expression I gave you have the both conditions:

It will sum [# Of Purchases] only if count of [# Of Purchases] are greater than 10 and [YTD Amount] >10,000

Is that is what you are looking for ?

Highlighted
Creator II
Creator II

No, the table will have 3 columns.  Name, # of Purchases, YTD Amount.

I only want to see the # of Purchases that are greater than 10 and the YTD Amount is greater than 10,000.

So, I believe I will need two expressions.

Highlighted
Master II
Master II

Try as below:

Dimension: Name

Expression1:

Count({<[# Of Purchases]={"$(=Count([# Of Purchases])>10"},[YTD Amount] = {'>10,000'}>} [# Of Purchases])


Expression2:

Sum(YTD Amount)


Hope this helps...

Highlighted
Creator II
Creator II

[YTD Amount] is not a field that exists...it is an expression. 

Highlighted
Creator III
Creator III

Hi Cliff


First expression goes like this


Sum({<[# Of Purchases]={"$(=Count([# Of Purchases])>10"}>} [# Of Purchases])


And second one 


Sum({<[YTD Amount] = {'>10,000'}>}[YTD Amount])


Thanks

Karthik

Highlighted
Master II
Master II

Can you please share a small sample ....