topic Re: Regarding the Multiple Expression in the KPI in QlikView

Regarding the Multiple Expression in the KPI

Sunilkumar3 — Mon, 13 Mar 2023 13:30:09 GMT

Hi,

I want. to show Multiple Expression in the KPI.

Example:

By default :-

Sum({<Flag = {'YTD'}>}Sales)

if Month_year Dimension Selected then Sum(Sales)

So how to write the Expression in the KPI

Thanks & Regards,

Sunil Kumar

Re: Regarding the Multiple Expression in the KPI

mominh_uzaifa — Tue, 14 Mar 2023 05:50:05 GMT

Hello

Try this

if(GetSelectedCount(Month_year)>0,Sum(Sales),Sum({<Flag = {'YTD'}>}Sales))

Thanks & Regards,

Huzaifa Momin

Re: Regarding the Multiple Expression in the KPI

sarafoster — Wed, 15 Mar 2023 05:43:47 GMT

You can use the "if" function to create a conditional expression in your KPI that displays the YTD sales when the "Flag" dimension is selected, and the monthly sales when the "Month_year" dimension is selected. Here's an example expression:

if(GetSelectedCount(Flag) > 0, Sum({<Flag={'YTD'}>}Sales), if(GetSelectedCount(Month_year) > 0, Sum(Sales), 0))

This expression checks if either "Flag" or "Month_year" dimensions are selected, and based on that, calculates the corresponding sales value. If neither of these dimensions are selected, it will return a value of 0. UMR.com