topic Re: Expression in QlikView

Expression

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I have used the below logic as calculated dimension . Based on the highlighted condition

Here i need to get the Inovice_num only for one day ie.,if Date= varMaxDate i need to show only those invoice numbers.

Logic: =Aggr(If((SUM({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales) > 0),Inovice_num),Loc,APA0TX,Inovice_num)

Thanks..

Re: Expression

sdmech81 — Mon, 06 Feb 2017 11:58:58 GMT

Try to put this:

SUM({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales)

in variable and then pass that in expression above and try .

Else send the application by dong limited load here.

Sachin

Re: Expression

sunny_talwar — Mon, 06 Feb 2017 12:22:40 GMT

Does you chart have more than one dimension? Is Loc and APA0TX are dimensions also?

Also, what is the issue you are running into? Would you be able to share a sample?

Re: Expression

nareshthavidishetty — Mon, 06 Feb 2017 12:27:31 GMT

Hi,

This isan calculated dimension i don't need sum(sales)

Here condition is

If((SUM({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales) > 0) then show only those invoice numbers.

In the below logic i need to include one more condition to get only invoice #'s when date = varMaxDate.

Finally two conditions.

=Aggr( If((SUM({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales) > 0) ,Inovice_num),Loc,APA0TX,Inovice_num)

Thanks..

Re: Expression

nareshthavidishetty — Mon, 06 Feb 2017 12:29:21 GMT

Hi,

Loc and APA0TX were dimensions.

Thanks..

Re: Expression

sunny_talwar — Mon, 06 Feb 2017 12:30:05 GMT

Response to just one of the questions? How about other things I asked

Re: Expression

nareshthavidishetty — Mon, 06 Feb 2017 12:38:34 GMT

Hi,

Dimensions: Loc ,APA0TX and calculated dimension.

calculated dimension:

=Aggr( If((SUM({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales) > 0) ,Inovice_num),Loc,APA0TX,Inovice_num)

Here the condition is

If((SUM({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales) > 0) then show only those invoice numbers.

The final condition might be

when Date = varMaxDate and If((SUM({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales) > 0)

then show only those invoice #'s.

Thanks..

Re: Expression

nareshthavidishetty — Mon, 06 Feb 2017 13:43:37 GMT

Hi,

Please provide the updated query.

Thanks..

Re: Expression

sunny_talwar — Mon, 06 Feb 2017 13:47:33 GMT

Can you try this:

=Aggr(If(Sum({<Date = {'$(=varMaxDate)'}, flag = {'eSign'}, Category = {'Not Complete'}>} Sales) > 0, Inovice_num), Loc, APA0TX, Inovice_num)

Re: Expression

nareshthavidishetty — Mon, 06 Feb 2017 14:05:53 GMT

Hi,

I need condition like below.

=if(Date=$(varMaxDate),Aggr(If((SUM({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales) > 0),NEW),Loc,APA0TX,NEW),NEW)

Thanks..

Re: Expression

sunny_talwar — Mon, 06 Feb 2017 14:08:53 GMT

I guess this:

=Aggr(If(Sum({<Date = {'$(=varMaxDate)'}, flag = {'eSign'}, Category = {'Not Complete'}>} Sales) > 0 and Date = $(varMaxDate), Inovice_num), Loc, APA0TX, Inovice_num)

We won't really know if you get what you wanted just by looking at this expression. I would suggest to share a sample so that we can help you better

Re: Expression

nareshthavidishetty — Mon, 06 Feb 2017 14:18:17 GMT

how to post application securely

Re: Expression

vishsaggi — Mon, 06 Feb 2017 14:26:49 GMT

Follow this and upload your sample app:

Preparing examples for Upload - Reduction and Data Scrambling